SERVERDBSTATISTICS
This
statistical system table contains information on the database instance usageSERVERDBSTATISTICS
|
SERVERDBSIZE |
FIXED (10) |
Database instance size in pages |
|
MAXDATAPAGENO |
FIXED (10) |
Largest page number of the database instance |
|
MAXPERM |
FIXED (10) |
Number of pages of the database instance that can be used for non-temporary objects |
|
USEDPERM |
FIXED (10) |
Number of pages of the database instance used for non-temporary objects |
|
PCTUSEDPERM |
FIXED (10) |
Percentage of pages used for non-temporary objects |
|
USEDTMP |
FIXED (10) |
Number of database instance pages used for temporary objects |
|
PCTUSEDTMP |
FIXED (10) |
Percentage of pages used for temporary objects |
|
UNUSED |
FIXED (10) |
Number of unused pages |
|
PCTUNUSED |
FIXED (10) |
Percentage share of unused pages |
|
UPDATEDPERM |
FIXED (10) |
Number of modified pages for permanent objects |
|
SERVERDBFULL |
CHAR ( 3) |
YES: database instance full NO: database instance not full |
|
LOGSIZE |
FIXED (10) |
Size of the log area in pages |
|
USEDLOG |
FIXED (10) |
Number of log pages used |
|
PCTUSEDLOG |
FIXED (10) |
Percentage of log pages used |
|
PCTLOGNOTSAVED |
FIXED (10) |
Number of log pages not backed up |
|
PCTLOGNOTSAVED |
FIXED (10) |
Percentage of log pages not yet saved |
|
LOGSINCEBACKUP |
FIXED (10) |
Number of log pages written since the last complete or incremental data backup |
|
RESERVEDREDO |
FIXED (10) |
Number of pages in the data devspace reserved for recovery (redo area) |
|
LOGSEGMENTSIZE |
FIXED (10) |
Size of a log segment in pages |
|
SAVEPOINTS |
FIXED (10) |
Number of savepoints executed |
|
CHECKPOINTS |
FIXED (10) |
Number of checkpoints executed |