v$sysstat



 ST# NAME                                               CLASS        VALUE
---- -------------------------------------------------- ----- ------------
   0 logons cumulative                                      1          103
   1 logons current                                         1            8
   2 opened cursors cumulative                              1         2516
   3 opened cursors current                                 1            2
   4 user commits                                           1           18
   5 user rollbacks                                         1            2
   6 user calls                                             1         2448
   7 recursive calls                                        1        33674
   8 recursive cpu usage                                    1            0
   9 session logical reads                                  1       428633
  10 session stored procedure space                         1            0

column  ST# format 999
column  NAME format A50
column  CLASS format 999
column  VALUE format 99999999999
select STATISTIC# ST# ,NAME,CLASS,VALUE from v$sysstat;

SQL> desc v$statname
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 STATISTIC#                                         NUMBER
 NAME                                               VARCHAR2(64)
 CLASS                                              NUMBER


Questions or comments ? Send a note to Kyle Hailey