Query V$SYSSTAT for all cumulative system-level statistics. : v_Sysstat « System Tables Views « Oracle PL / SQL






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>

   
  








Related examples in the same category