Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sorting and temporary tablespace used history info

sorting and temporary tablespace used history info

From: <hippodog2001_at_yahoo.com>
Date: 4 May 2007 18:13:05 -0700
Message-ID: <1178327585.879212.93770@u30g2000hsc.googlegroups.com>


Hi,
Is there any v$ view to find out sorting history, not an active sort information...?

For e.g.
In the morning, you see your temporary tablespace has been eaten up. you want to find out which SQL_ID performed sort operation (assume sort in this case) have eaten up your temporary tablespace during the night.
You can query v$sort_usage, or v$tempseg_usage, those views won't give you the sort history information, but only gives you current running query sorting information.

Shed any light? Thanks for your info... Received on Fri May 04 2007 - 20:13:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US