sorts (disk) and v$sort_usage

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? Received on Thu Jun 08 2006 - 12:41:53 CDT