Re: storage parameters
If the uniform-sized extents are sized so that the initial load will have to allocate 50 or 100 or 400 extents, how much processing overhead do you think that dictionary-managed extent allocation operation will really consume, especially if the search of FET$ within those operations is made simpler by uniform-sized extents throughout the tablespace? Quite insignificant. Please measure it sometime... This opposed to the wasted effort by DBAs/developers in attempting to calculate the correct sized initial extent for each table, plus the wasted processing in searching the FET$ table when the tablespace inevitably becomes fragmented due to non-uniform extent sizes, not to mention the time wasted by sales charlatans selling the latest defragmentation tool. I'm always struck by the way such tablespace defragmentation utilities resemble hangover remedies that include large amounts of alcohol... :-) Yeah, it makes you feel good -- for a couple more hours. Then... The concept of extents was devised to introduce the ability to adapt to long-term growth in space management. It is a tool to be used wisely, not a nuisance to be overcome. Following the train of thought of one extent good, many extents bad is simply wrong and a slippery slope to frustration... Wise use involves uniform-sized extents when possible, or at least a small number of extent sizes which are multiples of one another, as a second-best. The locally-managed tablespace mechanism shows both of those best practices encapsulated. The mechanism introduced in Oracle8 v8.0 of the MINIMUM EXTENT clause for the CREATE/ALTER TABLESPACE command with dictionary-managed tablespaces represents an earlier attempt at the same set of best practices... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 2:01 PM Rachel Carmichael wrote: An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. why? there is no benefit to that Rachel, No benefit when the data is loaded, but there is justification to it if it avoids extent allocations during the load - at least for a dictionary managed tablespace. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Tim Gorman 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: storage parameters
We're one game away from beating the Red Wings; how are the Maple Leafs doing? I haven't been paying attention... ...the Red Wings are the better coached and are just the better team, but the Avs are showing enough grit to take the lead in the series. Gotta love it... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 1:03 PM Hi Fazia, I would recommend the following white paper, it advocates using the SAFE methodology. HOW TO STOP DEFRAGMENTIING AND START LIVING Bhaskar Himatsingka, Oracle Corporation Juan Loaiza, Oracle Corporation You can find the paper on Cary Millsap's site. www.hotsos.com Sincerely, Jay Jay Earle, BSc(CS) ([EMAIL PROTECTED]) DBA, Operations Group SmartForce, Learning Solutions for the Human Enterprise -Original Message- Sent: Tuesday, May 28, 2002 3:30 PM To: Multiple recipients of list ORACLE-L An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. why? there is no benefit to that --- basher 59 [EMAIL PROTECTED] wrote: No. I can think of several reason when you would not wan them the save. An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. Example: Say 100M and then you may want to make next extents 5M. Based on the fact that you won't be reaching the second extent for a while. Also the temp tablespace is used to sort. I had an instance where the sorts were taking a long time. I looked at the temp tablespace and found out that my current sort was using 300 extents of a very small size. I increase my extent size to a large number, where the sort only took 4 extents and it really speeded up my sort. To optimize everything I look at the majority of my sorts and tried to make my first entent give me 90 % of these sorts. Which was somewhat small, and then I made my next extents large enough so my largest sort did not use more than about (5 to 10) extents. MN From: Malik, Fawzia [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: storage parameters Date: Tue, 28 May 2002 08:18:37 -0800 Hi, Does Oracle reccommend having the initial and next extents set at the same values??? I am tidying up a current schema and the values are non uniform all the way through- any comments would be very much appreciated Rgds Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: basher 59 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL
RE: storage parameters
Fawzia - If you're going to this much effort, consider looking into locally managed tablespaces (LMT) with uniform extents. Then you won't have to tidy up again. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 28, 2002 11:19 AM To: Multiple recipients of list ORACLE-L Hi, Does Oracle reccommend having the initial and next extents set at the same values??? I am tidying up a current schema and the values are non uniform all the way through- any comments would be very much appreciated Rgds Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia 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: 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: storage parameters
No. I can think of several reason when you would not wan them the save. An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. Example: Say 100M and then you may want to make next extents 5M. Based on the fact that you won't be reaching the second extent for a while. Also the temp tablespace is used to sort. I had an instance where the sorts were taking a long time. I looked at the temp tablespace and found out that my current sort was using 300 extents of a very small size. I increase my extent size to a large number, where the sort only took 4 extents and it really speeded up my sort. To optimize everything I look at the majority of my sorts and tried to make my first entent give me 90 % of these sorts. Which was somewhat small, and then I made my next extents large enough so my largest sort did not use more than about (5 to 10) extents. MN From: Malik, Fawzia [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: storage parameters Date: Tue, 28 May 2002 08:18:37 -0800 Hi, Does Oracle reccommend having the initial and next extents set at the same values??? I am tidying up a current schema and the values are non uniform all the way through- any comments would be very much appreciated Rgds Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: basher 59 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: storage parameters
An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. why? there is no benefit to that --- basher 59 [EMAIL PROTECTED] wrote: No. I can think of several reason when you would not wan them the save. An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. Example: Say 100M and then you may want to make next extents 5M. Based on the fact that you won't be reaching the second extent for a while. Also the temp tablespace is used to sort. I had an instance where the sorts were taking a long time. I looked at the temp tablespace and found out that my current sort was using 300 extents of a very small size. I increase my extent size to a large number, where the sort only took 4 extents and it really speeded up my sort. To optimize everything I look at the majority of my sorts and tried to make my first entent give me 90 % of these sorts. Which was somewhat small, and then I made my next extents large enough so my largest sort did not use more than about (5 to 10) extents. MN From: Malik, Fawzia [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: storage parameters Date: Tue, 28 May 2002 08:18:37 -0800 Hi, Does Oracle reccommend having the initial and next extents set at the same values??? I am tidying up a current schema and the values are non uniform all the way through- any comments would be very much appreciated Rgds Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: basher 59 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: storage parameters
Hi Fazia, I would recommend the following white paper, it advocates using the SAFE methodology. HOW TO STOP DEFRAGMENTIING AND START LIVING Bhaskar Himatsingka, Oracle Corporation Juan Loaiza, Oracle Corporation You can find the paper on Cary Millsap's site. www.hotsos.com Sincerely, Jay Jay Earle, BSc(CS) ([EMAIL PROTECTED]) DBA, Operations Group SmartForce, Learning Solutions for the Human Enterprise -Original Message- Sent: Tuesday, May 28, 2002 3:30 PM To: Multiple recipients of list ORACLE-L An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. why? there is no benefit to that --- basher 59 [EMAIL PROTECTED] wrote: No. I can think of several reason when you would not wan them the save. An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. Example: Say 100M and then you may want to make next extents 5M. Based on the fact that you won't be reaching the second extent for a while. Also the temp tablespace is used to sort. I had an instance where the sorts were taking a long time. I looked at the temp tablespace and found out that my current sort was using 300 extents of a very small size. I increase my extent size to a large number, where the sort only took 4 extents and it really speeded up my sort. To optimize everything I look at the majority of my sorts and tried to make my first entent give me 90 % of these sorts. Which was somewhat small, and then I made my next extents large enough so my largest sort did not use more than about (5 to 10) extents. MN From: Malik, Fawzia [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: storage parameters Date: Tue, 28 May 2002 08:18:37 -0800 Hi, Does Oracle reccommend having the initial and next extents set at the same values??? I am tidying up a current schema and the values are non uniform all the way through- any comments would be very much appreciated Rgds Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: basher 59 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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
Re: storage parameters
LOL! Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 2:58 PM I have to respectfully disagree. Creating everything in one huge extent and so called defragmentation are extremely important and save thousands of jobs at Seagate, Conner, Quantum, Maxtor, EMC and Hitachi. I cannot overemphasize an importance of such policy for the healthy growth of the storage industry. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: storage parameters An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. why? there is no benefit to that --- basher 59 [EMAIL PROTECTED] wrote: No. I can think of several reason when you would not wan them the save. An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. Example: Say 100M and then you may want to make next extents 5M. Based on the fact that you won't be reaching the second extent for a while. Also the temp tablespace is used to sort. I had an instance where the sorts were taking a long time. I looked at the temp tablespace and found out that my current sort was using 300 extents of a very small size. I increase my extent size to a large number, where the sort only took 4 extents and it really speeded up my sort. To optimize everything I look at the majority of my sorts and tried to make my first entent give me 90 % of these sorts. Which was somewhat small, and then I made my next extents large enough so my largest sort did not use more than about (5 to 10) extents. MN From: Malik, Fawzia [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: storage parameters Date: Tue, 28 May 2002 08:18:37 -0800 Hi, Does Oracle reccommend having the initial and next extents set at the same values??? I am tidying up a current schema and the values are non uniform all the way through- any comments would be very much appreciated Rgds Fawzia * * Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. * * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: basher 59 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858
RE: storage parameters
of course, I was selfishly thinking of this only from the perspective of the DBA and not the pocketbooks of the storage manufacturers --- Gogala, Mladen [EMAIL PROTECTED] wrote: I have to respectfully disagree. Creating everything in one huge extent and so called defragmentation are extremely important and save thousands of jobs at Seagate, Conner, Quantum, Maxtor, EMC and Hitachi. I cannot overemphasize an importance of such policy for the healthy growth of the storage industry. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: storage parameters An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. why? there is no benefit to that --- basher 59 [EMAIL PROTECTED] wrote: No. I can think of several reason when you would not wan them the save. An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. Example: Say 100M and then you may want to make next extents 5M. Based on the fact that you won't be reaching the second extent for a while. Also the temp tablespace is used to sort. I had an instance where the sorts were taking a long time. I looked at the temp tablespace and found out that my current sort was using 300 extents of a very small size. I increase my extent size to a large number, where the sort only took 4 extents and it really speeded up my sort. To optimize everything I look at the majority of my sorts and tried to make my first entent give me 90 % of these sorts. Which was somewhat small, and then I made my next extents large enough so my largest sort did not use more than about (5 to 10) extents. MN From: Malik, Fawzia [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: storage parameters Date: Tue, 28 May 2002 08:18:37 -0800 Hi, Does Oracle reccommend having the initial and next extents set at the same values??? I am tidying up a current schema and the values are non uniform all the way through- any comments would be very much appreciated Rgds Fawzia * * Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. * * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: basher 59 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services
Re: storage parameters
Rachel Carmichael wrote: An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. why? there is no benefit to that Rachel, No benefit when the data is loaded, but there is justification to it if it avoids extent allocations during the load - at least for a dictionary managed tablespace. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: storage parameters
but if the load is a one time thing (as he described) then the allocation hit happens only once and I still don't see a benefit and in fact can see how it might hurt -- tablespace fragmentation etc I'd rather see large extents but more of them --- Stephane Faroult [EMAIL PROTECTED] wrote: Rachel Carmichael wrote: An example: Think of load a lot of data into a table, and then load on a very limited basis. This tells me to create a large first extent that everything can fit into. why? there is no benefit to that Rachel, No benefit when the data is loaded, but there is justification to it if it avoids extent allocations during the load - at least for a dictionary managed tablespace. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).