RE: LOCALLY MANAGED TABLESPACE
Seema Oracle version? Have you studied the paper How to Stop Defragmenting . . . so you understand how to configure your LMT? Overall, my results with LMT have been great. Oracle says eventually we will all be LMT. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
I will say, welcome to the club. -Original Message- Sent: Tuesday, June 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LOCALLY MANAGED TABLESPACE
group view? if you mean, where can you find the information about the tablespace and datafiles, that is in the same set of views as dictionary-managed tablespaces: dba_tablespaces dba_data_files if that's not what you meant... please clarify what it is that you are looking for --- Seema Singh [EMAIL PROTECTED] wrote: Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
and that including the PEOPLESOFT guys too... -Original Message- Sent: Tuesday, June 24, 2003 5:45 PM To: Multiple recipients of list ORACLE-L Seema Oracle version? Have you studied the paper How to Stop Defragmenting . . . so you understand how to configure your LMT? Overall, my results with LMT have been great. Oracle says eventually we will all be LMT. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regis Biassala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
8.1.7.4 and 9i From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: LOCALLY MANAGED TABLESPACE Date: Tue, 24 Jun 2003 08:44:39 -0800 Seema Oracle version? Have you studied the paper How to Stop Defragmenting . . . so you understand how to configure your LMT? Overall, my results with LMT have been great. Oracle says eventually we will all be LMT. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
What is the group view on your going with the locally managed tablespaces? Well, go ahead, make my data! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
I am on 9iR2 , AIX 5L. I have all my tablespaces as locally managed including system. No problem yet. Shaibal Talukder Discover Financial Services Oracle Engineering [EMAIL PROTECTED] From: Seema Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: LOCALLY MANAGED TABLESPACE Date: Tue, 24 Jun 2003 09:19:48 -0800 8.1.7.4 and 9i From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: LOCALLY MANAGED TABLESPACE Date: Tue, 24 Jun 2003 08:44:39 -0800 Seema Oracle version? Have you studied the paper How to Stop Defragmenting . . . so you understand how to configure your LMT? Overall, my results with LMT have been great. Oracle says eventually we will all be LMT. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shaibal Talukder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
If you are tyring to use a LM temporary tablespace how about creating a second tablespace, temporary that is lcoally managed and then slowly alter the user, maybe even try and doa little test with a queryt hat will sue temporary space, run the query with one user on the normal dict man tablespace and the second user on the LM nd see if you can convince your boss now as the best time, They like to see that it works. If it does then they will sya yes sooner. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- Sent: 01 November 2002 19:46 PM To: Multiple recipients of list ORACLE-L Very, very lucky. I've been trying to get permission to move just my temporary tablespace to locally managed for months. My boss' boss refuses to give the okay until after our standby database is moved to a new location (if anyone can explain why those two things are related in any way I'd be overjoyed). And yes, I pointed out that every other database (either new or migrated before DBA responsibilities got shifted to someone who knows nothing about databases) has been using locally managed tablespaces and that our QA and QC testing went perfectly. Jay Miller -Original Message- Sent: Friday, October 25, 2002 12:14 PM To: Multiple recipients of list ORACLE-L You are lucky, very lucky... -Original Message- Sent: Friday, October 25, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Pardon the ignorance, I'm simply trying to understand... What is meant by management in this context? I'm can't imagine a circumstance under which ANY business manager would have a say on what goes on in the black box called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can see the input on those issues. But, all the way down to extent management?? Or am I simply lucky to not have that level of bureaucracy? Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC -Original Message- Sent: Friday, October 25, 2002 10:29 AM To: Multiple recipients of list ORACLE-L Same here Getting management to first understand the extent issue on Dictionary managed was a interesting exercise. Now trying to break that understanding down when wanting to use LMT is like double the work, painful. Difficult thing trying to educate them enough to understand something but not leaving at the same time halve way where you start getting these interesting architecture decisions or ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- Sent: 25 October 2002 13:04 PM To: Multiple recipients of list ORACLE-L The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE why did management care? - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, October 25, 2002 7:04 AM Subject: RE: LOCALLY MANAGED TABLESPACE The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE Good question I don't know ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Friday, October 25, 2002 10:29 AMTo: Multiple recipients of list ORACLE-LSubject: Re: LOCALLY MANAGED TABLESPACE why did management care? - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, October 25, 2002 7:04 AM Subject: RE: LOCALLY MANAGED TABLESPACE The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE Same here Getting management to first understand the extent issue on Dictionary managed was a interesting exercise. Now trying to break that understanding down when wanting to use LMT is like double the work, painful. Difficult thing trying to educate them enough to understand something but not leaving at the same time halve way where you start getting these interesting architecture decisions or ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel:(+27 11) 575 0573 Fax:(+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: 25 October 2002 13:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: LOCALLY MANAGED TABLESPACE The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE In a 'converted/migrated' LMT, tables/indexes can not take advantage ofUNIFORMor SYSTEM (autoallocate) policy of extent management. Those objects still grow with their old'next' extent sizes. For full benefits of LMT, consider creating new LMT tablespaces and moving objects to them. Search Metalink. There are a number of documents/notes on converting DMT to LMT. - Kirti -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Friday, October 25, 2002 8:04 AMTo: Multiple recipients of list ORACLE-LSubject: RE: LOCALLY MANAGED TABLESPACE The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE Pardon the ignorance, I'm simply trying to understand... What is meant by "management" in this context? I'm can't imagine a circumstance under whichANY business manager would have a say on what goes on in the black box called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can see the input on those issues. But, all the way down to extent management?? Or am I simply lucky to not have that level of bureaucracy? Gary WeberSenior DBACharles Jones, LLC||Superior Information Services, LLC -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Leonard, GeorgeSent: Friday, October 25, 2002 10:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: LOCALLY MANAGED TABLESPACE Same here Getting management to first understand the extent issue on Dictionary managed was a interesting exercise. Now trying to break that understanding down when wanting to use LMT is like double the work, painful. Difficult thing trying to educate them enough to understand something but not leaving at the same time halve way where you start getting these interesting architecture decisions or ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel:(+27 11) 575 0573 Fax:(+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: 25 October 2002 13:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: LOCALLY MANAGED TABLESPACE The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE You are lucky, very lucky... -Original Message-From: Gary Weber [mailto:[EMAIL PROTECTED]]Sent: Friday, October 25, 2002 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: LOCALLY MANAGED TABLESPACE Pardon the ignorance, I'm simply trying to understand... What is meant by "management" in this context? I'm can't imagine a circumstance under whichANY business manager would have a say on what goes on in the black box called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can see the input on those issues. But, all the way down to extent management?? Or am I simply lucky to not have that level of bureaucracy? Gary WeberSenior DBACharles Jones, LLC||Superior Information Services, LLC -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Leonard, GeorgeSent: Friday, October 25, 2002 10:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: LOCALLY MANAGED TABLESPACE Same here Getting management to first understand the extent issue on Dictionary managed was a interesting exercise. Now trying to break that understanding down when wanting to use LMT is like double the work, painful. Difficult thing trying to educate them enough to understand something but not leaving at the same time halve way where you start getting these interesting architecture decisions or ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel:(+27 11) 575 0573 Fax:(+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: 25 October 2002 13:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: LOCALLY MANAGED TABLESPACE The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE Some business managers migrate (pardon the pun) from being a techie to a bean counter type. So they know. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Gary Weber [mailto:[EMAIL PROTECTED]]Sent: Friday, October 25, 2002 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: LOCALLY MANAGED TABLESPACE Pardon the ignorance, I'm simply trying to understand... What is meant by "management" in this context? I'm can't imagine a circumstance under whichANY business manager would have a say on what goes on in the black box called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can see the input on those issues. But, all the way down to extent management?? Or am I simply lucky to not have that level of bureaucracy? Gary WeberSenior DBACharles Jones, LLC||Superior Information Services, LLC *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE Or am I simply lucky to not have that level of bureaucracy - You are lucky We are busy going into production for a big project, during the rollout and data take on the managers wanted to know all these things, it comes down to them not just accepting it when you tell them how long something takes. Then you have the manager that managed Oracle some time ago that remember DMT and have worked with LMT so converting them is difficult. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel:(+27 11) 575 0573 Fax:(+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- From: Gary Weber [mailto:[EMAIL PROTECTED]] Sent: 25 October 2002 15:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: LOCALLY MANAGED TABLESPACE Pardon the ignorance, I'm simply trying to understand... What is meant by management in this context? I'm can't imagine a circumstance under whichANY business manager would have a say on what goes on in the black box called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can see the input on those issues. But, all the way down to extent management?? Or am I simply lucky to not have that level of bureaucracy? Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Leonard, George Sent: Friday, October 25, 2002 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: LOCALLY MANAGED TABLESPACE Same here Getting management to first understand the extent issue on Dictionary managed was a interesting exercise. Now trying to break that understanding down when wanting to use LMT is like double the work, painful. Difficult thing trying to educate them enough to understand something but not leaving at the same time halve way where you start getting these interesting architecture decisions or ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel:(+27 11) 575 0573 Fax:(+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: 25 October 2002 13:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: LOCALLY MANAGED TABLESPACE The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema
Re: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE It's a question of responsibilities, not knowledge. Knowing something does not mean that one should continue to be involved. Most managers (or directors or VPs) whocontinue to be concerned in thistechnical detailare not paying attention to the things to which they should be paying attention.Sure sign of anewbie manager and the most common symptom of the "Peter Principle"... - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, October 25, 2002 10:24 AM Subject: RE: LOCALLY MANAGED TABLESPACE Some business managers migrate (pardon the pun) from being a techie to a bean counter type. So they know. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Gary Weber [mailto:[EMAIL PROTECTED]]Sent: Friday, October 25, 2002 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: LOCALLY MANAGED TABLESPACE Pardon the ignorance, I'm simply trying to understand... What is meant by "management" in this context? I'm can't imagine a circumstance under whichANY business manager would have a say on what goes on in the black box called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can see the input on those issues. But, all the way down to extent management?? Or am I simply lucky to not have that level of bureaucracy? Gary WeberSenior DBACharles Jones, LLC||Superior Information Services, LLC
RE: LOCALLY MANAGED TABLESPACE
The other thing I've encountered is where a consultant comes in and makes a fuss about the number of extents. Usually privately to a manager, then leaves, so you don't have an opportunity to discuss the issue. Or a GUI tool is demonstrated that has a screen to find problems, and usually one of the things the tools view is the number of extents so they can alert you to a problem. Management seems to think some real experts created the tool, so when you claim it is bunk, they look at you in puzzlement. I think the problem is one that a lot of technical people face, even automobile mechanics. How can you be a competent technical person on one hand, and on the other hand, make non-technical people feel confident that you are really competent? Many is the highly competent technical person that got fired or force out of their job by nontechnical people. And very high is the salary of consultants that do both tasks well. You must consider not only the accuracy of your advice and comments, but how those remarks are perceived by the nontechnical people. I have often thought that keeping copies of the books you have authored prominently displayed is a good way, but then Rachel punctured that thought by saying that her authorship didn't play strongly in her last hire. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 25, 2002 12:19 PM To: Multiple recipients of list ORACLE-L It's a question of responsibilities, not knowledge. Knowing something does not mean that one should continue to be involved. Most managers (or directors or VPs) who continue to be concerned in this technical detail are not paying attention to the things to which they should be paying attention. Sure sign of a newbie manager and the most common symptom of the Peter Principle... - Original Message - To: Multiple mailto:ORACLE-L;fatcity.com recipients of list ORACLE-L Sent: Friday, October 25, 2002 10:24 AM Some business managers migrate (pardon the pun) from being a techie to a bean counter type. So they know. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, October 25, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Pardon the ignorance, I'm simply trying to understand... What is meant by management in this context? I'm can't imagine a circumstance under which ANY business manager would have a say on what goes on in the black box called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can see the input on those issues. But, all the way down to extent management?? Or am I simply lucky to not have that level of bureaucracy? Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE Tim, That's not the case, these guys aretechies .. now handling higher duties. They just haven't kept up with 9i yet ... and yes they do their job very well. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Friday, October 25, 2002 1:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: LOCALLY MANAGED TABLESPACE It's a question of responsibilities, not knowledge. Knowing something does not mean that one should continue to be involved. Most managers (or directors or VPs) whocontinue to be concerned in thistechnical detailare not paying attention to the things to which they should be paying attention.Sure sign of anewbie manager and the most common symptom of the "Peter Principle"... This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: LOCALLY MANAGED TABLESPACE
Seema, Our production Student Information database (8.1.7 under Win2k) has 40,000 tables and 60,000 indexes. It's a third party app designed for dBaseIV - go ahead and laugh, we do all the time (when we're not crying). Anyhow, we have to regularly clone out the data to a couple of other databases, both on HPUX. The different OS means we have to use export/import, not restore from hot backup or transportable tablespaces, to move the data. Both of the recipient databases (with dictionary-managed tablespaces) started out needing about 2 hours to drop all the tables and indexes (tables change, so we can't truncate) and about 6 hours to import the full dataset. After several refreshes the time requirement grew to almost 30 hours for each DB. I think the data dictionary tables that record info. about tables, indexes, and extents (someone else on this list could probably name the very ones) got totally mucked up (a techical term) after so many massive drops and creates. After I recreated the recipient tablespaces as locally-managed, drop and import times returned to 2 and 6 hours, respectively, and have remained there through numerous subsequent refreshes. Needless to say, we are *very* happy with LMTs. BTW, our Student Info. system is clunky (we're going to redesign it into a couple hundred partitioned tables with 40,000 views and 120,000 Instead-Of Triggers, but that's another story) but several thousand teachers and administrators basically like the way it manages our 80,000 students. How's that for a client base? Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 [EMAIL PROTECTED] Seema Singh oracledbam@ho To: Multiple recipients of list ORACLE-L tmail.com[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: LOCALLY MANAGED TABLESPACE om 10/24/2002 01:49 PM Please respond to ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema -- Author: Seema Singh INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
Seema - While you are planning your conversion, be sure to carefully read the paper: How to stop defragmenting and start living: The definitive word on fragmentation by Himatsingka and Loaiza so you really understand how to receive the benefits of LMTs. It is available on http://www.hotsos.com and on http://otn.oracle.com/deploy/availability/pdf/defrag.pdf Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema _ Unlimited Internet access for only $21.95/month. Try MSN! http://resourcecenter.msn.com/access/plans/2monthsfree.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE Metalink Note: 93771.1 -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: LOCALLY MANAGED TABLESPACE Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema _ Unlimited Internet access for only $21.95/month. Try MSN! http://resourcecenter.msn.com/access/plans/2monthsfree.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE
Why do you always SHOUT in your subject line? Or are you not aware of simple net-etiquettes? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 2:49 PM Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema _ Unlimited Internet access for only $21.95/month. Try MSN! http://resourcecenter.msn.com/access/plans/2monthsfree.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally Managed Tablespace Confusion
Title: RE: Locally Managed Tablespace Confusion I think it's because dba_segments (or dba_indexes) will show the initial/next specified at creation time, even though the extents were not created at that size. Look in dba_extents to see that all extents are the same size. Example: SQL select * from dba_tablespaces where tablespace_name = 'DATA_SMALL' ; TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS -- -- --- --- MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING EXTENT_MAN --- -- - - - -- ALLOCATIO PLU - --- DATA_SMALL 15360 15360 1 2147483645 0 15360 ONLINE PERMANENT LOGGING LOCAL UNIFORM NO SQL select distinct initial_extent, next_extent 2 from dba_segments 3 where tablespace_name = 'DATA_SMALL' ; INITIAL_EXTENT NEXT_EXTENT -- --- 15360 15360 SQL create table test (n number) tablespace data_small storage (initial 30720 next 30720) ; Table créée. SQL select distinct initial_extent, next_extent 2 from dba_segments 3 where tablespace_name = 'DATA_SMALL' ; INITIAL_EXTENT NEXT_EXTENT -- --- 15360 15360 30720 15360 SQL select distinct (bytes) from dba_extents where tablespace_name = 'DATA_SMALL' ; BYTES -- 15360 -Original Message- From: Pat Howe [mailto:[EMAIL PROTECTED]] I am confused about locally managed tablespaces. I created a locally managed tablespace called INDEX01 using UNIFORMED extents of 128K (131072bytes). I then imported in the tables and indexes from an different database. When I query DBA_TABLESPACES it shows that the tablespace has been created as LOCALLY MANAGED (128k extents) - this is good. But when I query DBA_INDEXES and DBA_SEGMENTS the indexes that reside in this LOCALLY MANAGED tablespaces show extents all over the map - this is bad. I expected that all indexes would be rebuilt using the new Locally Managed extent size of 128K - not true. Wuz up with that ? == select tablespace_name, initial_extent, next_extent, pct_increase, extent_management, allocation_type from dba_tablespaces where tablespace_name = 'INDEX04' ; TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT PCT_INCREASE EXTENT_MAN ALLOCATIO --- -- --- -- - INDEX04 131072 131072 0 LOCAL UNIFORM == select owner, index_name, tablespace_name,initial_extent, next_extent, min_extents, max_extents,pct_increase from sys.dba_indexes where tablespace_name = 'INDEX01' order by 4, 1, 2, 3 ; OWNER INDEX_NAME TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE --- --- --- -- --- --- --- - LAWCOPY WUPSET2 INDEX04 16384 131072 1 2147483645 0 == select segment_name, tablespace_name, initial_extent, next_extent, pct_increase from dba_segments where segment_name = 'WUPSET2' ; SEGMENT_NAME TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT PCT_INCREASE --- --- -- --- WUPSET2 INDEX04 16384 131072 0
RE: Locally Managed Tablespace
Hi Sajid, Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated. This should fix the problem. Moses -Original Message- Sent: Tuesday, January 15, 2002 12:50 PM To: Multiple recipients of list ORACLE-L Hi all I am getting this error while running a large query, I recently created this locally managed temp tablespace... Any advice on possible solutions, the tablespace is 5 gig ORA-01652: unable to extend temp segment by 32 in tablespace TEMP_LOCAL TIA -- Saj Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Moses Ngati Moya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally Managed Tablespace
Best possible solution: rewrite the query and try to avoid large sorts ... or split the query, and make use of temporary tables (by using CTAS) to save results of the first part ... HTH, Remco -Oorspronkelijk bericht- Van: Sajid Iqbal [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 15 januari 2002 10:50 Aan: Multiple recipients of list ORACLE-L Onderwerp: Locally Managed Tablespace Hi all I am getting this error while running a large query, I recently created this locally managed temp tablespace... Any advice on possible solutions, the tablespace is 5 gig ORA-01652: unable to extend temp segment by 32 in tablespace TEMP_LOCAL TIA -- Saj Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally Managed Tablespace
Please check whether tables involved/indexes involved have degree 1. Please make it 1 if not and try. If it becomes HASH sort instead of SORT this problem happens. You can check it degree from dba_tables or dba_indexes. You may use following query while running your job to establsish what type of sort.. select user,segtype,extents from v$sort_usage; Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 15 Jan 2002 07:15:31 -0800 Best possible solution: rewrite the query and try to avoid large sorts ... or split the query, and make use of temporary tables (by using CTAS) to save results of the first part ... HTH, Remco -Oorspronkelijk bericht- Van: Sajid Iqbal [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 15 januari 2002 10:50 Aan: Multiple recipients of list ORACLE-L Onderwerp: Locally Managed Tablespace Hi all I am getting this error while running a large query, I recently created this locally managed temp tablespace... Any advice on possible solutions, the tablespace is 5 gig ORA-01652: unable to extend temp segment by 32 in tablespace TEMP_LOCAL TIA -- Saj Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally Managed Tablespace
My question is do you excusively use up 5gig? if so, does your SQL results in Cartesian product? My shop ran into this and I had developers corrected the SQL and then never happen again. I still left the TEMP tablespace which is LMT to be 700MB. -Original Message- Sent: Tuesday, January 15, 2002 9:11 AM To: Multiple recipients of list ORACLE-L Please check whether tables involved/indexes involved have degree 1. Please make it 1 if not and try. If it becomes HASH sort instead of SORT this problem happens. You can check it degree from dba_tables or dba_indexes. You may use following query while running your job to establsish what type of sort.. select user,segtype,extents from v$sort_usage; Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 15 Jan 2002 07:15:31 -0800 Best possible solution: rewrite the query and try to avoid large sorts ... or split the query, and make use of temporary tables (by using CTAS) to save results of the first part ... HTH, Remco -Oorspronkelijk bericht- Van: Sajid Iqbal [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 15 januari 2002 10:50 Aan: Multiple recipients of list ORACLE-L Onderwerp: Locally Managed Tablespace Hi all I am getting this error while running a large query, I recently created this locally managed temp tablespace... Any advice on possible solutions, the tablespace is 5 gig ORA-01652: unable to extend temp segment by 32 in tablespace TEMP_LOCAL TIA -- Saj Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally managed tablespace
!! Please do not post Off Topic to this List !! Making Oracle simpler to work with I don't fear would put dba's out of work. A dba's role is far more involved than just the daily janitor work. Planning is also a large part of our job as well. But let's think about this, look at Windows, a monkey can learn how to use it in 30 seconds to a minute, yet we still have many many system administrators. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 7:35 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Chris - As I understand it, locally managed tablespaces with uniform extents, possibly autoextensible, is the future direction for Oracle. This will allow Oracle to be more easily managed. Probably put us DBAs out of work, but hey something always seems to come up. The documentation states that locally managed tablespaces can create extents faster than dictionary managed, but I have never reached a point where it seemed to make a difference. But I am using the locally managed alternative more because of the nudge from Oracle's direction. Those are my thoughts anyway. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally managed tablespace
!! Please do not post Off Topic to this List !! I use LMT's a lot. Advantages 1. Avoids honeycomb fragmentation 2. Simple administration 3. Avoid the need for rebuilding due to fragmented extents 4. Faster when dealing with local extents 5. No need to coalesce (hense eliminate problems with SMON) Disadvantages 6. No rollback generated during space management 7. Reduced data dictionary contention Disadvantage 1. Not very well understood 2. Deciding common sizes for objects in the same tablespace may be a little more difficult. 3. When accessing xxx_EXTENTS all data files bitmaps are hit and may cause large performance problems when dealing with all extents across the database 4. All extent information is spread across many data files, so simple global extent operations may involve visiting many blocks. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 6:15 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Anyone here tried to use those locally managed tablespace? Some DBA here persuade me to use the locally managed TS for the rollback segment,tables, indexes, temp tablespace Can you tell me what are the benefits of using the locally managed tablespace, any disadvantages? Thanks in advance. Chris Harvest. Creative Consulting. __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally managed tablespace
!! Please do not post Off Topic to this List !! How are you to create the rollback segments? Is this the same or different from the other LMT tablespaces. I see where the Temporary Tablespaces are different. Any other good LMT articles besides the one below? I want to change our database into LMT and can you believe this was a brand new 8.1.6 database created in April and they used LONG datatypes and other old architecture. Kathy -Original Message- Sent: Thursday, September 13, 2001 4:05 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! !! tsiL siht ot cipoT ffO tsop ton od esaelP !! You can read this article to get some info: http://www.oracle.com/oramag/oracle/00-nov/index.html?o60o8i.html Ed -Original Message- Sent: Thursday, September 13, 2001 6:15 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Anyone here tried to use those locally managed tablespace? Some DBA here persuade me to use the locally managed TS for the rollback segment,tables, indexes, temp tablespace Can you tell me what are the benefits of using the locally managed tablespace, any disadvantages? Thanks in advance. Chris Harvest. Creative Consulting. __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Locally managed tablespace
!! Please do not post Off Topic to this List !! Since you can't usually predict which rollback segment a particular transaction is going to use anyway, generally accepted best practice is to create a dedicated tablespace (or usually one per instance for OPS) for rollback segments, enough rollback segments, and all rollback segments of the same size, the same optimal, and the same extent sizes (obviously - there is no initial or next in the syntax for creating a rollback segment itself). You might also need a monster to use with set transaction use rollback... for monster batch-like jobs and it could be an exception to the rule. In the message(s) that I posted, the implication was that the small set of extent sizes for the entire database would be for everything except SYSTEM, RBS, and TEMP. The meaning is that if your choice of extent sizes was, for example, 128K, 4M, and 128M, it would not restrict extent sizes for rollback or temp to one of those values. Use extent sizes for rollback and temp that are appropriate to each. Extent size for the TEMP tablespace should a function of SORT_AREA_SIZE. (I'll let someone else take the baton on that one if necessary.) -Don Granaman [OraSaurus - Honk if you remember UFI!] Create rollback segments as you would for - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 14, 2001 1:10 PM !! Please do not post Off Topic to this List !! How are you to create the rollback segments? Is this the same or different from the other LMT tablespaces. I see where the Temporary Tablespaces are different. Any other good LMT articles besides the one below? I want to change our database into LMT and can you believe this was a brand new 8.1.6 database created in April and they used LONG datatypes and other old architecture. Kathy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally managed tablespace
!! Please do not post Off Topic to this List !! So if I understand you correctly, I should have rollback segments and temp segments different for each of the different extent sizes I choice. So if I have tablespaces with 128K, 1M and 4M I should have private rollbacks segments set up for each of these. Is the syntax for creating a rollback segment different for LMT? I know with temporary tablespaces it is different. Kathy -Original Message- Sent: Friday, September 14, 2001 1:50 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Since you can't usually predict which rollback segment a particular transaction is going to use anyway, generally accepted best practice is to create a dedicated tablespace (or usually one per instance for OPS) for rollback segments, enough rollback segments, and all rollback segments of the same size, the same optimal, and the same extent sizes (obviously - there is no initial or next in the syntax for creating a rollback segment itself). You might also need a monster to use with set transaction use rollback... for monster batch-like jobs and it could be an exception to the rule. In the message(s) that I posted, the implication was that the small set of extent sizes for the entire database would be for everything except SYSTEM, RBS, and TEMP. The meaning is that if your choice of extent sizes was, for example, 128K, 4M, and 128M, it would not restrict extent sizes for rollback or temp to one of those values. Use extent sizes for rollback and temp that are appropriate to each. Extent size for the TEMP tablespace should a function of SORT_AREA_SIZE. (I'll let someone else take the baton on that one if necessary.) -Don Granaman [OraSaurus - Honk if you remember UFI!] Create rollback segments as you would for - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 14, 2001 1:10 PM !! Please do not post Off Topic to this List !! How are you to create the rollback segments? Is this the same or different from the other LMT tablespaces. I see where the Temporary Tablespaces are different. Any other good LMT articles besides the one below? I want to change our database into LMT and can you believe this was a brand new 8.1.6 database created in April and they used LONG datatypes and other old architecture. Kathy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally managed tablespace
!! Please do not post Off Topic to this List !! 1) Oracle is thy database and you will not have any other databases your machines. 2) There are no such things as private rollback segments. Thou shalt not create rollback segments with differing extent sizes. 3) Thou shalt have all of your rollback segments in the locally managed tablespaces to avoid overhead incurred when the dictionary extents tables are managed because of extending/shrinking rollback segments. 4) Thou shalt disable shrinking of rollback segments by not setting the optimal parameter. Please visit me on Mt. Sinai for the next 6 commandments. -Original Message- From: Kathy Duret [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 5:36 PM To: Multiple recipients of list ORACLE-L Subject: RE: Locally managed tablespace !! Please do not post Off Topic to this List !! So if I understand you correctly, I should have rollback segments and temp segments different for each of the different extent sizes I choice. So if I have tablespaces with 128K, 1M and 4M I should have private rollbacks segments set up for each of these. Is the syntax for creating a rollback segment different for LMT? I know with temporary tablespaces it is different. Kathy -Original Message- Sent: Friday, September 14, 2001 1:50 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Since you can't usually predict which rollback segment a particular transaction is going to use anyway, generally accepted best practice is to create a dedicated tablespace (or usually one per instance for OPS) for rollback segments, enough rollback segments, and all rollback segments of the same size, the same optimal, and the same extent sizes (obviously - there is no initial or next in the syntax for creating a rollback segment itself). You might also need a monster to use with set transaction use rollback... for monster batch-like jobs and it could be an exception to the rule. In the message(s) that I posted, the implication was that the small set of extent sizes for the entire database would be for everything except SYSTEM, RBS, and TEMP. The meaning is that if your choice of extent sizes was, for example, 128K, 4M, and 128M, it would not restrict extent sizes for rollback or temp to one of those values. Use extent sizes for rollback and temp that are appropriate to each. Extent size for the TEMP tablespace should a function of SORT_AREA_SIZE. (I'll let someone else take the baton on that one if necessary.) -Don Granaman [OraSaurus - Honk if you remember UFI!] Create rollback segments as you would for - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 14, 2001 1:10 PM !! Please do not post Off Topic to this List !! How are you to create the rollback segments? Is this the same or different from the other LMT tablespaces. I see where the Temporary Tablespaces are different. Any other good LMT articles besides the one below? I want to change our database into LMT and can you believe this was a brand new 8.1.6 database created in April and they used LONG datatypes and other old architecture. Kathy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: Locally managed tablespace
!! Please do not post Off Topic to this List !! !! tsiL siht ot cipoT ffO tsop ton od esaelP !! You can read this article to get some info: http://www.oracle.com/oramag/oracle/00-nov/index.html?o60o8i.html Ed -Original Message- Sent: Thursday, September 13, 2001 6:15 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Anyone here tried to use those locally managed tablespace? Some DBA here persuade me to use the locally managed TS for the rollback segment,tables, indexes, temp tablespace Can you tell me what are the benefits of using the locally managed tablespace, any disadvantages? Thanks in advance. Chris Harvest. Creative Consulting. __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally managed tablespace
!! Please do not post Off Topic to this List !! Chris - As I understand it, locally managed tablespaces with uniform extents, possibly autoextensible, is the future direction for Oracle. This will allow Oracle to be more easily managed. Probably put us DBAs out of work, but hey something always seems to come up. The documentation states that locally managed tablespaces can create extents faster than dictionary managed, but I have never reached a point where it seemed to make a difference. But I am using the locally managed alternative more because of the nudge from Oracle's direction. Those are my thoughts anyway. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally Managed Tablespace Uniform Extent
My understanding was that the main reason to keep the number of extents down was in case you needed to drop or truncate the table it would take Oracle a long time to clean up the fet$ table. I think, and I emphasize that I am not certain of this, that this is no longer a problem with locally managed tablespaces. I'm sure someone will correct me if I'm wrong... Jay Miller -Original Message- Sent: Wednesday, March 14, 2001 4:59 PM To: Multiple recipients of list ORACLE-L Jim, I'm probably a bit extreme here, but, with all due respect to Steve Adams (because I really do), I wouldn't worry terribly much about numbers of extents. Our 8.1.6 production db on Win2k has 8KB block size and uniform extent size of 1MB in all tablespaces. Our largest segment stores the out-of-line CLOBs of a partition of our largest table - it has over 22,000 extents. Another partition has a CLOB segment of over 18,000 extents. Since we hit those segments by RowID during InterMedia Text index queries, we've had absolutely no performance problems - we get 1 to 5 second response times. Actually, the InterMedia Text index segments have over 1,000 extents. A bunch of our tables with non-LOB data have hundreds of extents as well, which probably puts them in line with Steve's guidelines, but I wouldn't be worried if they got up into the thousands of extents. I'm sure there are numerous situations where different extent sizes in different tablespaces makes sense. Maybe I'm just too lazy. We don't have that many small tables where 1MB extents waste a lot of space and, like I said, I don't worry about too many extents, though if extents approached the hundreds of thousands, I might create a tablespace or two with large extents for those segments. I've just not seen really convincing arguments that large (but not huge) numbers of extents cause significant performance problems, especially compared to the really BAD SQL that Duhvelopers seem so fond of writing. ;-) A big advantage is that I can't even remember the last time I worried about coelescing and fragmentation! Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Jim Walski Sent: Wednesday, March 14, 2001 2:10 PM To: Multiple recipients of list ORACLE-L I have to move a 7.3.4 database to 8i and I want to use the uniform extent size to reduce fragmentation. I read the article "stop defragmenting and start living" and it indicates to have 3 extent sizes - 128K, 4M, 128M. I also read an article on Steve Adams site that indicates to keep the number of extents under (db_block_size/16) - 7 ( which in my case 8k block) would be 505 extents. ) In the database I am moving there are some segments that are currently 1GB in size, if i was to put those in the 4M tablespace it would already have over 250 extents starting off. Are there any other performance type issues to consider? Should I create another extent size between 4M and the 128M? Maybe 64M increment? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally Managed Tablespace Uniform Extent
Title: RE: Locally Managed Tablespace Uniform Extent -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] My understanding was that the main reason to keep the number of extents down was in case you needed to drop or truncate the table it would take Oracle a long time to clean up the fet$ table. I think, and I emphasize that I am not certain of this, that this is no longer a problem with locally managed tablespaces. I'm sure someone will correct me if I'm wrong... As usual, Steve Adams has some sage advice on the subject. Check out his article Planning Extents http://www.ixora.com.au (click on Tips then on Planning Extents) in which he mentions that there are reasons for keeping the number of extents down even in a locally managed tablespace.
RE: Locally Managed Tablespace Uniform Extent
I think its to keep the extents identifiable within the segment header block - sort of in the same way that oracle used to do in the earlier versions (which limited the extents to 121, 249, 505 etc dependent on block size) hth connor --- Jacques Kilchoer [EMAIL PROTECTED] wrote: -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] My understanding was that the main reason to keep the number of extents down was in case you needed to drop or truncate the table it would take Oracle a long time to clean up the fet$ table. I think, and I emphasize that I am not certain of this, that this is no longer a problem with locally managed tablespaces. I'm sure someone will correct me if I'm wrong... As usual, Steve Adams has some sage advice on the subject. Check out his article "Planning Extents" http://www.ixora.com.au (click on Tips then on Planning Extents) in which he mentions that there are reasons for keeping the number of extents down even in a locally managed tablespace. = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Locally Managed Tablespace Uniform Extent
The advice on Metalink is sound in the sense that using a finite number of extent sizes is a good thing, but (imho) the choice of sizes for extents is largely up to you (a point that the article doesn't really convey). The key with the uniform extent is avoiding fragmentation issues; combine that with local mgt and the dictionary contention issues pretty much disappear as well. I don't think the actual size of the extents is relevant (once you get well above sizes relative to the max physical read limit). Thus if you've got 1G segments, just use a 50M or 100M uniform extent sizes in the appropriate tablespaces. My typical sizes are 256k, 2m, 20m and 200m. hth connor --- Jim Walski [EMAIL PROTECTED] wrote: I have to move a 7.3.4 database to 8i and I want to use the uniform extent size to reduce fragmentation. I read the article "stop defragmenting and start living" and it indicates to have 3 extent sizes - 128K, 4M, 128M. I also read an article on Steve Adams site that indicates to keep the number of extents under (db_block_size/16) - 7 ( which in my case ( 8k block) would be 505 extents. ) In the database I am moving there are some segments that are currently 1GB in size, if i was to put those in the 4M tablespace it would already have over 250 extents starting off. Are there any other performance type issues to consider? Should I create another extent size between 4M and the 128M? Maybe 64M increment? Thanks, Jim Jim Walski ClassicPlan Chino, CA 91710 email [EMAIL PROTECTED] http://www.classicplan.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally Managed Tablespace Uniform Extent
Jim, I'm probably a bit extreme here, but, with all due respect to Steve Adams (because I really do), I wouldn't worry terribly much about numbers of extents. Our 8.1.6 production db on Win2k has 8KB block size and uniform extent size of 1MB in all tablespaces. Our largest segment stores the out-of-line CLOBs of a partition of our largest table - it has over 22,000 extents. Another partition has a CLOB segment of over 18,000 extents. Since we hit those segments by RowID during InterMedia Text index queries, we've had absolutely no performance problems - we get 1 to 5 second response times. Actually, the InterMedia Text index segments have over 1,000 extents. A bunch of our tables with non-LOB data have hundreds of extents as well, which probably puts them in line with Steve's guidelines, but I wouldn't be worried if they got up into the thousands of extents. I'm sure there are numerous situations where different extent sizes in different tablespaces makes sense. Maybe I'm just too lazy. We don't have that many small tables where 1MB extents waste a lot of space and, like I said, I don't worry about too many extents, though if extents approached the hundreds of thousands, I might create a tablespace or two with large extents for those segments. I've just not seen really convincing arguments that large (but not huge) numbers of extents cause significant performance problems, especially compared to the really BAD SQL that Duhvelopers seem so fond of writing. ;-) A big advantage is that I can't even remember the last time I worried about coelescing and fragmentation! Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Jim Walski Sent: Wednesday, March 14, 2001 2:10 PM To: Multiple recipients of list ORACLE-L I have to move a 7.3.4 database to 8i and I want to use the uniform extent size to reduce fragmentation. I read the article "stop defragmenting and start living" and it indicates to have 3 extent sizes - 128K, 4M, 128M. I also read an article on Steve Adams site that indicates to keep the number of extents under (db_block_size/16) - 7 ( which in my case 8k block) would be 505 extents. ) In the database I am moving there are some segments that are currently 1GB in size, if i was to put those in the 4M tablespace it would already have over 250 extents starting off. Are there any other performance type issues to consider? Should I create another extent size between 4M and the 128M? Maybe 64M increment? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).