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).
Received on Tue Jul 08 2003 - 16:36:12 CDT
