ORACLE DBA BLOG

col program form a30 heading "Program" col CPUMins form 99990 heading "CPU in Mins" select rownum as rank , a . * from ( SELECT v . sid , program , v . value / ( 100 * 60 ) CPUMins FROM v $ statname s , v $ sesstat v , v $ session sess WHERE s . name = 'CPU used by this session' and sess . sid = v . sid and v . statistic #=s.statistic# and v . value > 0 ORDER BY v . value DESC ) a where rownum < 11 ;

set pagesize 299 set lines 299 select STAT_NAME , to_char ( VALUE ) as VALUE    , COMMENTS from v $ osstat where stat_name   IN ( 'NUM_CPUS' , 'NUM_CPU_CORES' , 'NUM_CPU_SOCKETS' ) union select STAT_NAME , VALUE / 1024 / 1024 / 1024 || ' GB'    , COMMENTS from v $ osstat where stat_name   IN ( 'PHYSICAL_MEMORY_BYTES' )