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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 08 Jun 2006 20:51:44 +0200
Message-ID: <adsg82pt9au70e2i6lbb1p47bcdcskqd3v@4ax.com>


On 8 Jun 2006 10:41:53 -0700, niy38_at_hotmail.com wrote:

>select a.name,b.value from v$statname a, v$sesstat b
> where a.statistic#=b.statistic# and a.name='sorts (disk)'
> and b.sid in (select sid from v$session where saddr in (select
>session_addr from v$sort_usage));
>
>
>returns all value is 0, anyone explain?

Because there are no sorts to disk going on?

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Jun 08 2006 - 13:51:44 CDT

Original text of this message

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