Oracle PL/SQL/System Tables Views/v Sysstat

Материал из 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>