DB 「v$**」動的パフォーマンスビュー

Oracle_4-100

データベースの動的パフォーマンスビューの一覧

データベースの代表的な動的パフォーマンスビューの一覧とその構成です。

 

DB動的パフォーマンスビュー

v$archived_log
v$backup
v$controlfile
v$database
v$datafile
v$instance
v$log
v$log_history
v$logfile
v$nls_parameters
v$option
v$parameter
v$process
v$recover_file
v$recovery_log
v$session
v$sga
v$tablespace
v$tempfile
v$version

 

v$archived_log

select RECID,STAMP,NAME,DEST_ID,THREAD#,SEQUENCE#,RESETLOGS_CHANGE#,RESETLOGS_TIME,RESETLOGS_ID,FIRST_CHANGE#,FIRST_TIME,NEXT_CHANGE#,NEXT_TIME,BLOCKS,BLOCK_SIZE,CREATOR,REGISTRAR,STANDBY_DEST,ARCHIVED,APPLIED,DELETED,STATUS,COMPLETION_TIME,DICTIONARY_BEGIN,DICTIONARY_END,END_OF_REDO,BACKUP_COUNT,ARCHIVAL_THREAD#,ACTIVATION#,IS_RECOVERY_DEST_FILE,COMPRESSED,FAL,END_OF_REDO_TYPE,BACKED_BY_VSS from v$archived_log;

SQL> desc v$archived_log
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 RECID                                            NUMBER
 STAMP                                            NUMBER
 NAME                                             VARCHAR2(257)
 DEST_ID                                          NUMBER
 THREAD#                                          NUMBER
 SEQUENCE#                                        NUMBER
 RESETLOGS_CHANGE#                                NUMBER
 RESETLOGS_TIME                                   DATE
 RESETLOGS_ID                                     NUMBER
 FIRST_CHANGE#                                    NUMBER
 FIRST_TIME                                       DATE
 NEXT_CHANGE#                                     NUMBER
 NEXT_TIME                                        DATE
 BLOCKS                                           NUMBER
 BLOCK_SIZE                                       NUMBER
 CREATOR                                          VARCHAR2(7)
 REGISTRAR                                        VARCHAR2(7)
 STANDBY_DEST                                     VARCHAR2(3)
 ARCHIVED                                         VARCHAR2(3)
 APPLIED                                          VARCHAR2(9)
 DELETED                                          VARCHAR2(3)
 STATUS                                           VARCHAR2(1)
 COMPLETION_TIME                                  DATE
 DICTIONARY_BEGIN                                 VARCHAR2(3)
 DICTIONARY_END                                   VARCHAR2(3)
 END_OF_REDO                                      VARCHAR2(3)
 BACKUP_COUNT                                     NUMBER
 ARCHIVAL_THREAD#                                 NUMBER
 ACTIVATION#                                      NUMBER
 IS_RECOVERY_DEST_FILE                            VARCHAR2(3)
 COMPRESSED                                       VARCHAR2(3)
 FAL                                              VARCHAR2(3)
 END_OF_REDO_TYPE                                 VARCHAR2(10)
 BACKED_BY_VSS                                    VARCHAR2(3)

SQL>

 

v$backup

select FILE#,STATUS,CHANGE#,TIME from v$backup;

SQL> desc v$backup
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 FILE#                                            NUMBER
 STATUS                                           VARCHAR2(18)
 CHANGE#                                          NUMBER
 TIME                                             DATE

SQL>

 

v$controlfile

select STATUS,NAME,IS_RECOVERY_DEST_FILE,BLOCK_SIZE,FILE_SIZE_BLKS from v$controlfile;

SQL> desc v$controlfile
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 STATUS                                           VARCHAR2(7)
 NAME                                             VARCHAR2(257)
 IS_RECOVERY_DEST_FILE                            VARCHAR2(3)
 BLOCK_SIZE                                       NUMBER
 FILE_SIZE_BLKS                                   NUMBER

SQL>

 

v$database

select DBID,NAME,CREATED,RESETLOGS_CHANGE#,RESETLOGS_TIME,PRIOR_RESETLOGS_CHANGE#,PRIOR_RESETLOGS_TIME,LOG_MODE,CHECKPOINT_CHANGE#,ARCHIVE_CHANGE#,CONTROLFILE_TYPE,CONTROLFILE_CREATED,CONTROLFILE_SEQUENCE#,CONTROLFILE_CHANGE#,CONTROLFILE_TIME,OPEN_RESETLOGS,VERSION_TIME,OPEN_MODE,PROTECTION_MODE,PROTECTION_LEVEL,REMOTE_ARCHIVE,ACTIVATION#,SWITCHOVER#,DATABASE_ROLE,ARCHIVELOG_CHANGE#,ARCHIVELOG_COMPRESSION,SWITCHOVER_STATUS,DATAGUARD_BROKER,GUARD_STATUS,SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI,FORCE_LOGGING,PLATFORM_ID,PLATFORM_NAME,RECOVERY_TARGET_INCARNATION#,LAST_OPEN_INCARNATION#,CURRENT_SCN,FLASHBACK_ON,SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALL,DB_UNIQUE_NAME,STANDBY_BECAME_PRIMARY_SCN,FS_FAILOVER_STATUS,FS_FAILOVER_CURRENT_TARGET,FS_FAILOVER_THRESHOLD,FS_FAILOVER_OBSERVER_PRESENT,FS_FAILOVER_OBSERVER_HOST,CONTROLFILE_CONVERTED,PRIMARY_DB_UNIQUE_NAME,SUPPLEMENTAL_LOG_DATA_PL,MIN_REQUIRED_CAPTURE_CHANGE# from v$database;

SQL> desc v$database
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 DBID                                             NUMBER
 NAME                                             VARCHAR2(9)
 CREATED                                          DATE
 RESETLOGS_CHANGE#                                NUMBER
 RESETLOGS_TIME                                   DATE
 PRIOR_RESETLOGS_CHANGE#                          NUMBER
 PRIOR_RESETLOGS_TIME                             DATE
 LOG_MODE                                         VARCHAR2(12)
 CHECKPOINT_CHANGE#                               NUMBER
 ARCHIVE_CHANGE#                                  NUMBER
 CONTROLFILE_TYPE                                 VARCHAR2(7)
 CONTROLFILE_CREATED                              DATE
 CONTROLFILE_SEQUENCE#                            NUMBER
 CONTROLFILE_CHANGE#                              NUMBER
 CONTROLFILE_TIME                                 DATE
 OPEN_RESETLOGS                                   VARCHAR2(11)
 VERSION_TIME                                     DATE
 OPEN_MODE                                        VARCHAR2(20)
 PROTECTION_MODE                                  VARCHAR2(20)
 PROTECTION_LEVEL                                 VARCHAR2(20)
 REMOTE_ARCHIVE                                   VARCHAR2(8)
 ACTIVATION#                                      NUMBER
 SWITCHOVER#                                      NUMBER
 DATABASE_ROLE                                    VARCHAR2(16)
 ARCHIVELOG_CHANGE#                               NUMBER
 ARCHIVELOG_COMPRESSION                           VARCHAR2(8)
 SWITCHOVER_STATUS                                VARCHAR2(20)
 DATAGUARD_BROKER                                 VARCHAR2(8)
 GUARD_STATUS                                     VARCHAR2(7)
 SUPPLEMENTAL_LOG_DATA_MIN                        VARCHAR2(8)
 SUPPLEMENTAL_LOG_DATA_PK                         VARCHAR2(3)
 SUPPLEMENTAL_LOG_DATA_UI                         VARCHAR2(3)
 FORCE_LOGGING                                    VARCHAR2(3)
 PLATFORM_ID                                      NUMBER
 PLATFORM_NAME                                    VARCHAR2(101)
 RECOVERY_TARGET_INCARNATION#                     NUMBER
 LAST_OPEN_INCARNATION#                           NUMBER
 CURRENT_SCN                                      NUMBER
 FLASHBACK_ON                                     VARCHAR2(18)
 SUPPLEMENTAL_LOG_DATA_FK                         VARCHAR2(3)
 SUPPLEMENTAL_LOG_DATA_ALL                        VARCHAR2(3)
 DB_UNIQUE_NAME                                   VARCHAR2(30)
 STANDBY_BECAME_PRIMARY_SCN                       NUMBER
 FS_FAILOVER_STATUS                               VARCHAR2(22)
 FS_FAILOVER_CURRENT_TARGET                       VARCHAR2(30)
 FS_FAILOVER_THRESHOLD                            NUMBER
 FS_FAILOVER_OBSERVER_PRESENT                     VARCHAR2(7)
 FS_FAILOVER_OBSERVER_HOST                        VARCHAR2(256)
 CONTROLFILE_CONVERTED                            VARCHAR2(3)
 PRIMARY_DB_UNIQUE_NAME                           VARCHAR2(30)
 SUPPLEMENTAL_LOG_DATA_PL                         VARCHAR2(3)
 MIN_REQUIRED_CAPTURE_CHANGE#                     NUMBER

SQL>

 

v$datafile

select FILE#,CREATION_CHANGE#,CREATION_TIME,TS#,RFILE#,STATUS,ENABLED,CHECKPOINT_CHANGE#,CHECKPOINT_TIME,UNRECOVERABLE_CHANGE#,UNRECOVERABLE_TIME,LAST_CHANGE#,LAST_TIME,OFFLINE_CHANGE#,ONLINE_CHANGE#,ONLINE_TIME,BYTES,BLOCKS,CREATE_BYTES,BLOCK_SIZE,NAME,PLUGGED_IN,BLOCK1_OFFSET,AUX_NAME,FIRST_NONLOGGED_SCN,FIRST_NONLOGGED_TIME,FOREIGN_DBID,FOREIGN_CREATION_CHANGE#,FOREIGN_CREATION_TIME,PLUGGED_READONLY,PLUGIN_CHANGE#,PLUGIN_RESETLOGS_CHANGE#,PLUGIN_RESETLOGS_TIME from v$datafile;

SQL> desc v$datafile
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 FILE#                                            NUMBER
 CREATION_CHANGE#                                 NUMBER
 CREATION_TIME                                    DATE
 TS#                                              NUMBER
 RFILE#                                           NUMBER
 STATUS                                           VARCHAR2(7)
 ENABLED                                          VARCHAR2(10)
 CHECKPOINT_CHANGE#                               NUMBER
 CHECKPOINT_TIME                                  DATE
 UNRECOVERABLE_CHANGE#                            NUMBER
 UNRECOVERABLE_TIME                               DATE
 LAST_CHANGE#                                     NUMBER
 LAST_TIME                                        DATE
 OFFLINE_CHANGE#                                  NUMBER
 ONLINE_CHANGE#                                   NUMBER
 ONLINE_TIME                                      DATE
 BYTES                                            NUMBER
 BLOCKS                                           NUMBER
 CREATE_BYTES                                     NUMBER
 BLOCK_SIZE                                       NUMBER
 NAME                                             VARCHAR2(257)
 PLUGGED_IN                                       NUMBER
 BLOCK1_OFFSET                                    NUMBER
 AUX_NAME                                         VARCHAR2(257)
 FIRST_NONLOGGED_SCN                              NUMBER
 FIRST_NONLOGGED_TIME                             DATE
 FOREIGN_DBID                                     NUMBER
 FOREIGN_CREATION_CHANGE#                         NUMBER
 FOREIGN_CREATION_TIME                            DATE
 PLUGGED_READONLY                                 VARCHAR2(3)
 PLUGIN_CHANGE#                                   NUMBER
 PLUGIN_RESETLOGS_CHANGE#                         NUMBER
 PLUGIN_RESETLOGS_TIME                            DATE

SQL>

 

v$instance

select INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,PARALLEL,THREAD#,ARCHIVER,LOG_SWITCH_WAIT,LOGINS,SHUTDOWN_PENDING,DATABASE_STATUS,INSTANCE_ROLE,ACTIVE_STATE,BLOCKED from v$instance;

SQL> desc v$instance
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 INSTANCE_NUMBER                                  NUMBER
 INSTANCE_NAME                                    VARCHAR2(16)
 HOST_NAME                                        VARCHAR2(64)
 VERSION                                          VARCHAR2(17)
 STARTUP_TIME                                     DATE
 STATUS                                           VARCHAR2(12)
 PARALLEL                                         VARCHAR2(3)
 THREAD#                                          NUMBER
 ARCHIVER                                         VARCHAR2(7)
 LOG_SWITCH_WAIT                                  VARCHAR2(15)
 LOGINS                                           VARCHAR2(10)
 SHUTDOWN_PENDING                                 VARCHAR2(3)
 DATABASE_STATUS                                  VARCHAR2(17)
 INSTANCE_ROLE                                    VARCHAR2(18)
 ACTIVE_STATE                                     VARCHAR2(9)
 BLOCKED                                          VARCHAR2(3)

SQL>

 

v$log

select GROUP#,THREAD#,SEQUENCE#,BYTES,BLOCKSIZE,MEMBERS,ARCHIVED,STATUS,FIRST_CHANGE#,FIRST_TIME,NEXT_CHANGE#,NEXT_TIME from v$log;

SQL> desc v$log
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 GROUP#                                           NUMBER
 THREAD#                                          NUMBER
 SEQUENCE#                                        NUMBER
 BYTES                                            NUMBER
 BLOCKSIZE                                        NUMBER
 MEMBERS                                          NUMBER
 ARCHIVED                                         VARCHAR2(3)
 STATUS                                           VARCHAR2(16)
 FIRST_CHANGE#                                    NUMBER
 FIRST_TIME                                       DATE
 NEXT_CHANGE#                                     NUMBER
 NEXT_TIME                                        DATE

SQL>

 

v$log_history

select RECID,STAMP,THREAD#,SEQUENCE#,FIRST_CHANGE#,FIRST_TIME,NEXT_CHANGE#,RESETLOGS_CHANGE#,RESETLOGS_TIME from v$log_history;

SQL> desc v$log_history
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 RECID                                            NUMBER
 STAMP                                            NUMBER
 THREAD#                                          NUMBER
 SEQUENCE#                                        NUMBER
 FIRST_CHANGE#                                    NUMBER
 FIRST_TIME                                       DATE
 NEXT_CHANGE#                                     NUMBER
 RESETLOGS_CHANGE#                                NUMBER
 RESETLOGS_TIME                                   DATE

SQL>

 

v$logfile

select GROUP#,STATUS,TYPE,MEMBER,IS_RECOVERY_DEST_FILE from v$logfile;

SQL> desc v$logfile
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 GROUP#                                           NUMBER
 STATUS                                           VARCHAR2(7)
 TYPE                                             VARCHAR2(7)
 MEMBER                                           VARCHAR2(257)
 IS_RECOVERY_DEST_FILE                            VARCHAR2(3)

SQL>

 

v$nls_parameters

select PARAMETER,VALUE from v$nls_parameters;

SQL> desc v$nls_parameters
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 PARAMETER                                        VARCHAR2(64)
 VALUE                                            VARCHAR2(64)

SQL>

 

v$option

select PARAMETER,VALUE from v$option;

SQL> desc v$option
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 PARAMETER                                        VARCHAR2(64)
 VALUE                                            VARCHAR2(64)

SQL>

 

v$parameter

select NUM,NAME,TYPE,VALUE,DISPLAY_VALUE,ISDEFAULT,ISSES_MODIFIABLE,ISSYS_MODIFIABLE,ISINSTANCE_MODIFIABLE,ISMODIFIED,ISADJUSTED,ISDEPRECATED,ISBASIC,DESCRIPTION,UPDATE_COMMENT,HASH from v$parameter;

SQL> desc v$parameter
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 NUM                                              NUMBER
 NAME                                             VARCHAR2(80)
 TYPE                                             NUMBER
 VALUE                                            VARCHAR2(4000)
 DISPLAY_VALUE                                    VARCHAR2(4000)
 ISDEFAULT                                        VARCHAR2(9)
 ISSES_MODIFIABLE                                 VARCHAR2(5)
 ISSYS_MODIFIABLE                                 VARCHAR2(9)
 ISINSTANCE_MODIFIABLE                            VARCHAR2(5)
 ISMODIFIED                                       VARCHAR2(10)
 ISADJUSTED                                       VARCHAR2(5)
 ISDEPRECATED                                     VARCHAR2(5)
 ISBASIC                                          VARCHAR2(5)
 DESCRIPTION                                      VARCHAR2(255)
 UPDATE_COMMENT                                   VARCHAR2(255)
 HASH                                             NUMBER

SQL>

 

v$process

select ADDR,PID,SPID,PNAME,USERNAME,SERIAL#,TERMINAL,PROGRAM,TRACEID,TRACEFILE,BACKGROUND,LATCHWAIT,LATCHSPIN,PGA_USED_MEM,PGA_ALLOC_MEM,PGA_FREEABLE_MEM,PGA_MAX_MEM from v$process;

SQL> desc v$process
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 ADDR                                             RAW(8)
 PID                                              NUMBER
 SPID                                             VARCHAR2(24)
 PNAME                                            VARCHAR2(5)
 USERNAME                                         VARCHAR2(15)
 SERIAL#                                          NUMBER
 TERMINAL                                         VARCHAR2(30)
 PROGRAM                                          VARCHAR2(48)
 TRACEID                                          VARCHAR2(255)
 TRACEFILE                                        VARCHAR2(257)
 BACKGROUND                                       VARCHAR2(1)
 LATCHWAIT                                        VARCHAR2(16)
 LATCHSPIN                                        VARCHAR2(16)
 PGA_USED_MEM                                     NUMBER
 PGA_ALLOC_MEM                                    NUMBER
 PGA_FREEABLE_MEM                                 NUMBER
 PGA_MAX_MEM                                      NUMBER

SQL>

 

v$recover_file

select FILE#,ONLINE,ONLINE_STATUS,ERROR,CHANGE#,TIME from v$recover_file;

SQL> desc v$recover_file
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 FILE#                                            NUMBER
 ONLINE                                           VARCHAR2(7)
 ONLINE_STATUS                                    VARCHAR2(7)
 ERROR                                            VARCHAR2(18)
 CHANGE#                                          NUMBER
 TIME                                             DATE

SQL>

 

v$recovery_log

select THREAD#,SEQUENCE#,TIME,ARCHIVE_NAME from v$recovery_log;

SQL> desc v$recovery_log
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 THREAD#                                          NUMBER
 SEQUENCE#                                        NUMBER
 TIME                                             DATE
 ARCHIVE_NAME                                     VARCHAR2(257)

SQL>

 

v$session

select SADDR,SID,SERIAL#,AUDSID,PADDR,USER#,USERNAME,COMMAND,OWNERID,TADDR,LOCKWAIT,STATUS,SERVER,SCHEMA#,SCHEMANAME,OSUSER,PROCESS,MACHINE,PORT,TERMINAL,PROGRAM,TYPE,SQL_ADDRESS,SQL_HASH_VALUE,SQL_ID,SQL_CHILD_NUMBER,SQL_EXEC_START,SQL_EXEC_ID,PREV_SQL_ADDR,PREV_HASH_VALUE,PREV_SQL_ID,PREV_CHILD_NUMBER,PREV_EXEC_START,PREV_EXEC_ID,PLSQL_ENTRY_OBJECT_ID,PLSQL_ENTRY_SUBPROGRAM_ID,PLSQL_OBJECT_ID,PLSQL_SUBPROGRAM_ID,MODULE,MODULE_HASH,ACTION,ACTION_HASH,CLIENT_INFO,FIXED_TABLE_SEQUENCE,ROW_WAIT_OBJ#,ROW_WAIT_FILE#,ROW_WAIT_BLOCK#,ROW_WAIT_ROW#,TOP_LEVEL_CALL#,LOGON_TIME,LAST_CALL_ET,PDML_ENABLED,FAILOVER_TYPE,FAILOVER_METHOD,FAILED_OVER,RESOURCE_CONSUMER_GROUP,PDML_STATUS,PDDL_STATUS,PQ_STATUS,CURRENT_QUEUE_DURATION,CLIENT_IDENTIFIER,BLOCKING_SESSION_STATUS,BLOCKING_INSTANCE,BLOCKING_SESSION,FINAL_BLOCKING_SESSION_STATUS,FINAL_BLOCKING_INSTANCE,FINAL_BLOCKING_SESSION,SEQ#,EVENT#,EVENT,P1TEXT,P1,P1RAW,P2TEXT,P2,P2RAW,P3TEXT,P3,P3RAW,WAIT_CLASS_ID,WAIT_CLASS#,WAIT_CLASS,WAIT_TIME,SECONDS_IN_WAIT,STATE,WAIT_TIME_MICRO,TIME_REMAINING_MICRO,TIME_SINCE_LAST_WAIT_MICRO,SERVICE_NAME,SQL_TRACE,SQL_TRACE_WAITS,SQL_TRACE_BINDS,SQL_TRACE_PLAN_STATS,SESSION_EDITION_ID,CREATOR_ADDR,CREATOR_SERIAL#,ECID from v$session;

SQL> desc v$session
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 SADDR                                            RAW(8)
 SID                                              NUMBER
 SERIAL#                                          NUMBER
 AUDSID                                           NUMBER
 PADDR                                            RAW(8)
 USER#                                            NUMBER
 USERNAME                                         VARCHAR2(30)
 COMMAND                                          NUMBER
 OWNERID                                          NUMBER
 TADDR                                            VARCHAR2(16)
 LOCKWAIT                                         VARCHAR2(16)
 STATUS                                           VARCHAR2(8)
 SERVER                                           VARCHAR2(9)
 SCHEMA#                                          NUMBER
 SCHEMANAME                                       VARCHAR2(30)
 OSUSER                                           VARCHAR2(30)
 PROCESS                                          VARCHAR2(24)
 MACHINE                                          VARCHAR2(64)
 PORT                                             NUMBER
 TERMINAL                                         VARCHAR2(30)
 PROGRAM                                          VARCHAR2(48)
 TYPE                                             VARCHAR2(10)
 SQL_ADDRESS                                      RAW(8)
 SQL_HASH_VALUE                                   NUMBER
 SQL_ID                                           VARCHAR2(13)
 SQL_CHILD_NUMBER                                 NUMBER
 SQL_EXEC_START                                   DATE
 SQL_EXEC_ID                                      NUMBER
 PREV_SQL_ADDR                                    RAW(8)
 PREV_HASH_VALUE                                  NUMBER
 PREV_SQL_ID                                      VARCHAR2(13)
 PREV_CHILD_NUMBER                                NUMBER
 PREV_EXEC_START                                  DATE
 PREV_EXEC_ID                                     NUMBER
 PLSQL_ENTRY_OBJECT_ID                            NUMBER
 PLSQL_ENTRY_SUBPROGRAM_ID                        NUMBER
 PLSQL_OBJECT_ID                                  NUMBER
 PLSQL_SUBPROGRAM_ID                              NUMBER
 MODULE                                           VARCHAR2(64)
 MODULE_HASH                                      NUMBER
 ACTION                                           VARCHAR2(64)
 ACTION_HASH                                      NUMBER
 CLIENT_INFO                                      VARCHAR2(64)
 FIXED_TABLE_SEQUENCE                             NUMBER
 ROW_WAIT_OBJ#                                    NUMBER
 ROW_WAIT_FILE#                                   NUMBER
 ROW_WAIT_BLOCK#                                  NUMBER
 ROW_WAIT_ROW#                                    NUMBER
 TOP_LEVEL_CALL#                                  NUMBER
 LOGON_TIME                                       DATE
 LAST_CALL_ET                                     NUMBER
 PDML_ENABLED                                     VARCHAR2(3)
 FAILOVER_TYPE                                    VARCHAR2(13)
 FAILOVER_METHOD                                  VARCHAR2(10)
 FAILED_OVER                                      VARCHAR2(3)
 RESOURCE_CONSUMER_GROUP                          VARCHAR2(32)
 PDML_STATUS                                      VARCHAR2(8)
 PDDL_STATUS                                      VARCHAR2(8)
 PQ_STATUS                                        VARCHAR2(8)
 CURRENT_QUEUE_DURATION                           NUMBER
 CLIENT_IDENTIFIER                                VARCHAR2(64)
 BLOCKING_SESSION_STATUS                          VARCHAR2(11)
 BLOCKING_INSTANCE                                NUMBER
 BLOCKING_SESSION                                 NUMBER
 FINAL_BLOCKING_SESSION_STATUS                    VARCHAR2(11)
 FINAL_BLOCKING_INSTANCE                          NUMBER
 FINAL_BLOCKING_SESSION                           NUMBER
 SEQ#                                             NUMBER
 EVENT#                                           NUMBER
 EVENT                                            VARCHAR2(64)
 P1TEXT                                           VARCHAR2(64)
 P1                                               NUMBER
 P1RAW                                            RAW(8)
 P2TEXT                                           VARCHAR2(64)
 P2                                               NUMBER
 P2RAW                                            RAW(8)
 P3TEXT                                           VARCHAR2(64)
 P3                                               NUMBER
 P3RAW                                            RAW(8)
 WAIT_CLASS_ID                                    NUMBER
 WAIT_CLASS#                                      NUMBER
 WAIT_CLASS                                       VARCHAR2(64)
 WAIT_TIME                                        NUMBER
 SECONDS_IN_WAIT                                  NUMBER
 STATE                                            VARCHAR2(19)
 WAIT_TIME_MICRO                                  NUMBER
 TIME_REMAINING_MICRO                             NUMBER
 TIME_SINCE_LAST_WAIT_MICRO                       NUMBER
 SERVICE_NAME                                     VARCHAR2(64)
 SQL_TRACE                                        VARCHAR2(8)
 SQL_TRACE_WAITS                                  VARCHAR2(5)
 SQL_TRACE_BINDS                                  VARCHAR2(5)
 SQL_TRACE_PLAN_STATS                             VARCHAR2(10)
 SESSION_EDITION_ID                               NUMBER
 CREATOR_ADDR                                     RAW(8)
 CREATOR_SERIAL#                                  NUMBER
 ECID                                             VARCHAR2(64)

SQL>

 

v$sga

select NAME,VALUE from v$sga;

SQL> desc v$sga
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 NAME                                             VARCHAR2(20)
 VALUE                                            NUMBER

SQL>

 

v$tablespace

select TS#,NAME,INCLUDED_IN_DATABASE_BACKUP,BIGFILE,FLASHBACK_ON,ENCRYPT_IN_BACKUP from v$tablespace;

SQL> desc v$tablespace
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 TS#                                              NUMBER
 NAME                                             VARCHAR2(30)
 INCLUDED_IN_DATABASE_BACKUP                      VARCHAR2(3)
 BIGFILE                                          VARCHAR2(3)
 FLASHBACK_ON                                     VARCHAR2(3)
 ENCRYPT_IN_BACKUP                                VARCHAR2(3)

SQL>

 

v$tempfile

select FILE#,CREATION_CHANGE#,CREATION_TIME,TS#,RFILE#,STATUS,ENABLED,BYTES,BLOCKS,CREATE_BYTES,BLOCK_SIZE,NAME from v$tempfile;

SQL> desc v$tempfile
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 FILE#                                            NUMBER
 CREATION_CHANGE#                                 NUMBER
 CREATION_TIME                                    DATE
 TS#                                              NUMBER
 RFILE#                                           NUMBER
 STATUS                                           VARCHAR2(7)
 ENABLED                                          VARCHAR2(10)
 BYTES                                            NUMBER
 BLOCKS                                           NUMBER
 CREATE_BYTES                                     NUMBER
 BLOCK_SIZE                                       NUMBER
 NAME                                             VARCHAR2(257)

SQL>

 

v$version

select BANNER from v$version;

SQL> desc v$version
 名前                                    NULL?    型
 --------------------------------------- -------- --------------------
 BANNER                                           VARCHAR2(80)

SQL>

 

 

 


サブコンテンツ

このページの先頭へ