Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query V$SYSSTAT for all cumulative system-level statistics

SQL> SQL> select Name,   2         Value   3    from V$SYSSTAT   4   order by Name; NAME ------------------------------------------------------      VALUE ---------- CPU used by this session       1011 CPU used when call started        781 CR blocks created        646 Cached Commit SCN referenced          0 Commit SCN cached          0 DB time     159685 DBWR checkpoint buffers written        635 DBWR checkpoints                           Page:   2 NAME ------------------------------------------------------      VALUE ----------        137 DBWR fusion writes          0 DBWR lru scans          0 DBWR make free requests          0 DBWR object drop buffers written         45 DBWR parallel query checkpoint buffers written          0 DBWR revisited being-written buffer          0 DBWR tablespace checkpoint buffers written          0 347 rows selected. SQL>