Datacentre Support Reference Guides

Visit our online shop for ALL your parts, components, laptops, electronics and gadgets
 

Instance static dba_ views

  
 

  1. v$database
  2. v$datafile
  3. v$datafile_header
  4. v$dbfile
  5. v$fixed_table
  6. v$instance
  7. v$parameter
  8. v$sga
v$database v$datafile
Shows database specific information Shows datafile information from control file perspective
Name Null? Type Name Null? Type
DBID Y NUMBER FILE# Y NUMBER
NAME Y VARCHAR2(9) CREATION_CHANGE# Y NUMBER
CREATED Y DATE CREATION_TIME Y DATE
RESETLOGS_CHANGE# Y NUMBER TS# Y NUMBER
RESETLOGS_TIME Y DATE RFILE# Y NUMBER
PRIOR_RESETLOGS_CHANGE# Y NUMBER STATUS Y VARCHAR2(7)
PRIOR_RESETLOGS_TIME Y DATE ENABLED Y VARCHAR2(10)
LOG_MODE Y VARCHAR2(12) CHECKPOINT_CHANGE# Y NUMBER
CHECKPOINT_CHANGE# Y NUMBER CHECKPOINT_TIME Y DATE
ARCHIVE_CHANGE# Y NUMBER UNRECOVERABLE_CHANGE# Y NUMBER
CONTROLFILE_TYPE Y VARCHAR2(7) UNRECOVERABLE_TIME Y DATE
CONTROLFILE_CREATED Y DATE LAST_CHANGE# Y NUMBER
CONTROLFILE_SEQUENCE# Y NUMBER LAST_TIME Y DATE
CONTROLFILE_CHANGE# Y NUMBER OFFLINE_CHANGE# Y NUMBER
CONTROLFILE_TIME Y DATE ONLINE_CHANGE# Y NUMBER
OPEN_RESETLOGS Y VARCHAR2(11) ONLINE_TIME Y DATE
VERSION_TIME Y DATE BYTES Y NUMBER
OPEN_MODE Y VARCHAR2(10) BLOCKS Y NUMBER
CREATE_BYTES Y NUMBER
BLOCK_SIZE Y NUMBER
NAME Y VARCHAR2(513)
PLUGGED_IN Y NUMBER
v$datafile_header v$dbfile
Shows the datafile header information Lookup table containing datafile number & name.
Name Null? Type Name Null? Type
FILE# Y NUMBER FILE# Y NUMBER
STATUS Y VARCHAR2(7) NAME Y VARCHAR2(513)
ERROR Y VARCHAR2(18)
FORMAT Y NUMBER
RECOVER Y VARCHAR2(3)
FUZZY Y VARCHAR2(3)
CREATION_CHANGE# Y NUMBER
CREATION_TIME Y DATE
TABLESPACE_NAME Y VARCHAR2(30)
TS# Y NUMBER
RFILE# Y NUMBER
RESETLOGS_CHANGE# Y NUMBER
RESETLOGS_TIME Y DATE
CHECKPOINT_CHANGE# Y NUMBER
CHECKPOINT_TIME Y DATE
CHECKPOINT_COUNT Y NUMBER
BYTES Y NUMBER
BLOCKS Y NUMBER
NAME Y VARCHAR2(513)
v$fixed_table v$instance
Lists the fixed objects; X$ tables, GV$ global views, and v$views. Shows the instance specific information
Name Null? Type Name Null? Type
NAME Y VARCHAR2(30) INSTANCE_NUMBER Y NUMBER
OBJECT_ID Y NUMBER INSTANCE_NAME Y VARCHAR2(16)
TYPE Y VARCHAR2(5) HOST_NAME Y VARCHAR2(64)
TABLE_NUM Y NUMBER VERSION Y VARCHAR2(17)
STARTUP_TIME Y DATE
STATUS Y VARCHAR2(7)
PARALLEL Y VARCHAR2(3)
THREAD# Y NUMBER
ARCHIVER Y VARCHAR2(7)
LOG_SWITCH_WAIT Y VARCHAR2(11)
LOGINS Y VARCHAR2(10)
SHUTDOWN_PENDING Y VARCHAR2(3)
DATABASE_STATUS Y VARCHAR2(17)
v$parameter v$sga
Lists each of the database parameters Constains summary SGA information.
Name Null? Type Name Null? Type
NUM Y NUMBER NAME Y VARCHAR2(20)
NAME Y VARCHAR2(64) VALUE Y NUMBER
TYPE Y NUMBER
VALUE Y VARCHAR2(512)
ISDEFAULT Y VARCHAR2(9)
ISSES_MODIFIABLE Y VARCHAR2(5)
ISSYS_MODIFIABLE Y VARCHAR2(9)
ISMODIFIED Y VARCHAR2(10)
ISADJUSTED Y VARCHAR2(5)
DESCRIPTION Y VARCHAR2(64)