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 -> Re: sorts (disk) and v$sort_usage

Re: sorts (disk) and v$sort_usage

From: <niy38_at_hotmail.com>
Date: 8 Jun 2006 14:39:26 -0700
Message-ID: <1149802766.825626.111110@j55g2000cwa.googlegroups.com>

Brian Peasland wrote:
> What happens if you rewrite the query as such:
>
> select a.name,b.value
> from v$statname a, v$sesstat b, v$session s, v$sort_usage su
> where a.statistic#=b.statistic# and b.sid=s.sid
> and s.saddr=su.session_addr
> and a.name='sorts (disk)';

returns all 0

>
> Also, did you check the segment type (SEGTYPE) in V$SORT_USAGE to
> determine if the temporary segment is really a sort segment? According
> to Jonathan Lewis in this Metalink thread
> (https://metalink.oracle.com/metalink/plsql/f?p=200:27:1683701837942099652::::p27_id,p27_show_header,p27_show_help:279353.999,1,1),
> V$SORT_USAGE will show more than just disk sorts. The sort segment in
> V$SORT_USAGE can be temporary tables, open cursors or some temporary
> LOBs, in which case the session statistic for 'sorts (disk)' would not
> be increased.

SEGTYPE is DATA,INDEX,LOB_DATA Received on Thu Jun 08 2006 - 16:39:26 CDT

Original text of this message

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