Re: sorts (disk) and v$sort_usage

Sybrand Bakker wrote:
> 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?
>
> --

v$sort_usage is not empty, which mean temporary tablespace is used. Received on Thu Jun 08 2006 - 15:27:12 CDT