DB 「v$**」動的パフォーマンスビュー
データベースの動的パフォーマンスビューの一覧
データベースの代表的な動的パフォーマンスビューの一覧とその構成です。
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>
タグ：oracle11gR2, v$表, 動的パフォーマンスビュー
