Re: sorts (disk) and v$sort_usage

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