Re: Sort statistics in 8.1.6

Anton Buijs wrote:

> SELECT s.sid, n.name, s.value FROM v$sesstat s, v$statname n
> WHERE s.statistic# = n.statistic#
> AND s.sid = <sid of a session>
> AND n.name like '%sort%';
>
> and maybe some other statistics.
> Run the query before the session ends.
> V$SYSSTAT show the statistics database wide since uptime.
> V$SESSTAT show the statitstics per session.
> V$STATNAME describes the statistic numbers and is used to join with
> v$SESSTAT. Don't write scripts based on the numbers, they can (an do!)
> change with every version.

Thank you very much for your response.

The problem is that these statistics can tell me only whether disk was used. The problem is that there is a need for more specific information: how many merge phases have been carried out for the particular statement?

I know that this information is there somewhere (there is an example output in docs), but I do not know how to retrieve it.

The example output is:

• Sort Statistics ------------------------------ Initial runs 13553 Intermediate runs 2258 Number of merges 2259 ...

But how to get such stats?

-- 
Maciej Sobczak
http://www.maciejsobczak.com/