v$sort_usage and v$sort_segment are always a good
start
hth
connor
- "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> wrote: >
I'd start looking at the execution plans first and
> examine if there is any
> Cartesian joins and the order the tables get joined.
>
> Waleed
>
> -----Original Message-----
> Sent: Tuesday, September 17, 2002 10:34 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> I have a problem with a process and its temp segment
> usage.
>
> Previously, in RBO (8161) we used to run 8 reports
> with slightly different
> parameters in parallel and it used to work fine with
> all other load on the
> system and the total TEMP space was 6GB
>
> Since we migrated to CBO (all tables & indexes are
> analyzed using estimate),
> these processes fail with unable to extent temp
> segment error. Currently we
> have allocated 12GB to temp tablespace.
>
> I also have performance issues so I am doing a 10046
> trace at level 8 on
> this one. Is there a way to identify when this
> process used temp space, how
> much and when does it de-allocate?
>
> Would this information be available in 10046 trace
> or is there something
> else that I could do to track that ...
>
> Thanks in advance
> 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!
>
>
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Remember amateurs built the ark - Professionals built the Titanic"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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: ListGuru_at_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).
Received on Wed Sep 18 2002 - 12:18:31 CDT