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