v$sort_usage and v$sort_segment are always a good start hth connor
--- "Khedr, Waleed" <[EMAIL PROTECTED]> 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: [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).