V$SYSSTAT

Cumulative statistics since the last startup of the database.

Columns
   ___________________________
 
   STATISTIC#
   NAME
   CLASS
   VALUE


Example
Display the cumulative logons:

SELECT rpad(c.name||':',11)||
       rpad(' current logons='||(to_number(b.sessions_current)-1),20)||
       'cumulative logons='||rpad(substr(a.value,1,10),10)||
       'highwater mark='||b.sessions_highwater Information
FROM
  v$sysstat a,
  v$license b,
  v$database c
WHERE
  a.name = 'logons cumulative';

Related:

V$GLOBAL_TRANSACTION 
V$SHARED_POOL_RESERVED 
V$SORT_SEGMENT 
V$SORT_USAGE 
V$STATNAME 
V$SYSTEM_CURSOR_CACHE 
V$SYSTEM_EVENT 
V$TRANSACTION


© Copyright SS64.com 1999-2014
Some rights reserved