Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g4T2MMT25035 for ; Tue, 28 May 2002 22:22:22 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id LAA82949; Tue, 28 May 2002 11:18:17 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 0046D155; Tue, 28 May 2002 11:03:30 -0800 Message-ID: Date: Tue, 28 May 2002 11:03:30 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Jay Earle (DBA)" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Jay Earle (DBA)" Subject: RE: storage parameters Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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) (jay_earle@smartforce.com) 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 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" > >Reply-To: ORACLE-L@fatcity.com > >To: Multiple recipients of list ORACLE-L > >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: Fawzia.Malik@bskyb.com > > > >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: ListGuru@fatcity.com (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: kb7yss@hotmail.com > > 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: ListGuru@fatcity.com (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: wisernet100@yahoo.com 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: ListGuru@fatcity.com (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: Jay Earle (DBA) INET: Jay_Earle@smartforce.com 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: ListGuru@fatcity.com (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).