Sort_area_size is set to 50M for this session. almost 16000 sotrs in memory vs 23 sotrs on disk
Gene --- John Kanagaraj <[EMAIL PROTECTED]> wrote: > How about Sort_area_size? This will matter - check > for 'sorts to disk' and > 'sort rows' from that session's v$sesstat (joined to > v$statname). > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > Grace - Getting something we don't deserve; Mercy - > NOT getting something we > deserve > Click on 'http://www.needhim.org' for Grace and > Mercy that is freely > available! > > ** The opinions and statements above are entirely my > own and not those of my > employer or clients ** > > > > -----Original Message----- > > From: Gurelei [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, July 08, 2003 2:30 PM > > To: Multiple recipients of list ORACLE-L > > Subject: tunning an index built > > > > > > Hi. > > > > I'm trying to tune an index build. The table > currently > > has about 65mil rows and I'm building a unique > index, > > which takes about 55min to finish. The table size > is > > about 3.4G, index is about the same size. I have > tried > > different degrees of parallelism (up to 32), > nologging > > is set in the create index script as well as on > the > > tablespace. I noticed a lot of i/o waits during > the > > buid and a lot of paging to and from filesystem, > the > > paging area however appears to be unused. when I > do > > lsps -a, it only shows 1% usage. What should be my > > next move? What should I look at? i have increased > > db_cache to 800M, sort area to 50M > > > > thanks > > > > Gene > > > > __________________________________ > > 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: Gurelei > > 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: John Kanagaraj > 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: Gurelei 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).