Re: parse cpu and recursive cpu

Hi,

Do not use statistic numbers in your scripts, these might change over versions or differ by platforms. Use only statistic names.

For example stat# 233 is branch node splits in my 10.1.0.3 Linux/32bit system.

SQL> select statistic#, name from v$statname where statistic# in (8,233);

STATISTIC# NAME

---------- ----------------------------------------------------------------
         8 recursive cpu usage
       233 branch node splits

Tanel.

> Hello The Human Fly,
>
> just do the below query.:-)
>
> select * from v$mystat where statistic# in (8,233);
>

--
http://www.freelists.org/webpage/oracle-l