【Oracleインスタンスの管理 参考資料】 << V$PARAMETER >> SQL> desc v$parameter 名前 NULL? タイプ ------------------------------- -------- ---- NUM NUMBER NAME VARCHAR2(64) TYPE NUMBER VALUE VARCHAR2(512) ISDEFAULT VARCHAR2(9) ISSES_MODIFIABLE VARCHAR2(5) ISSYS_MODIFIABLE VARCHAR2(9) ISMODIFIED VARCHAR2(10) ISADJUSTED VARCHAR2(5) DESCRIPTION VARCHAR2(64) SQL> col VALUE on format A100 SQL>select * from v$parameter where name in ('background_dump_dest','compatible','control_files','db_block_buffers','db_name', 'shared_pool_size','user_dump_dest') NUM NAME TYPE ---------- ---------------------------------------------------------------- ---------- VALUE ---------------------------------------------------------------------------------------------------- ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ --------- ----- --------- ---------- ----- DESCRIPTION ---------------------------------------------------------------- 36 shared_pool_size 2 100000000 FALSE FALSE FALSE FALSE FALSE size in bytes of shared pool 97 control_files 2 /cdb_ctl/ora_data1/cdbmicro.ctrl1, /cdb_ctl/ora_data2/cdbmicro.ctrl2 FALSE FALSE FALSE FALSE FALSE control file names list 101 db_block_buffers 3 35000 FALSE FALSE FALSE FALSE FALSE Number of database blocks cached in memory 132 compatible 2 8.0.0 TRUE FALSE FALSE FALSE FALSE Database will be completely compatible with this software versio 258 db_name 2 CDBMICRO FALSE FALSE FALSE FALSE FALSE database name specified in CREATE DATABASE 341 background_dump_dest 2 ?/rdbms/log FALSE FALSE IMMEDIATE FALSE FALSE Detached process dump directory 342 user_dump_dest 2 ?/rdbms/log FALSE FALSE IMMEDIATE FALSE FALSE User process dump directory 7行が選択されました。 SQL> col VALUE on format A30 SQL> select * from v$parameter where name in ('ifile','log_buffer','max_dump_file_size','processes','sql_trace','sort_area_size') NUM NAME TYPE ---------- ---------------------------------------------------------------- ---------- VALUE ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ ------------------------------ --------- ----- --------- ---------- ----- DESCRIPTION ---------------------------------------------------------------- 9 processes 3 110 FALSE FALSE FALSE FALSE FALSE user processes 142 log_buffer 3 163840 FALSE FALSE FALSE FALSE FALSE redo circular buffer size 250 sort_area_size 3 1048576 FALSE TRUE DEFERRED FALSE FALSE size of in-memory sort work area 260 ifile 4 TRUE FALSE FALSE FALSE FALSE include file in init.ora 261 sql_trace 1 FALSE FALSE FALSE FALSE FALSE FALSE enable SQL trace 343 max_dump_file_size 2 10000 TRUE TRUE IMMEDIATE FALSE FALSE Maximum size (blocks) of dump file 6行が選択されました。 << 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(7) PARALLEL VARCHAR2(3) THREAD# NUMBER ARCHIVER VARCHAR2(7) LOG_SWITCH_WAIT VARCHAR2(11) LOGINS VARCHAR2(10) SHUTDOWN_PENDING VARCHAR2(3) SQL> select * from V$INSTANCE; INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION --------------- ---------------- ---------------------------------------------------------------- ----------------- STARTUP_TIME STATUS PAR THREAD# ARCHIVE LOG_SWITCH_ LOGINS SHU ------------------- ------- --- ---------- ------- ----------- ---------- --- 1 cdbmicro madrid 8.0.5.1.0 2001-04-12 11:19:25 OPEN NO 1 STOPPED ALLOWED NO << V$FIXED_TABLE >> SQL> desc V$FIXED_TABLE 名前 NULL? タイプ ------------------------------- -------- ---- NAME VARCHAR2(30) OBJECT_ID NUMBER TYPE VARCHAR2(5) TABLE_NUM NUMBER SQL> select * from V$FIXED_TABLE where NAME like 'V$%' order by NAME; NAME OBJECT_ID TYPE TABLE_NUM ------------------------------ ---------- ----- ---------- V$ACCESS 4294950931 VIEW 65537 V$ACTIVE_INSTANCES 4294951195 VIEW 65537 V$AQ1 4294951442 VIEW 65537 V$ARCHIVE 4294950933 VIEW 65537 V$ARCHIVED_LOG 4294951220 VIEW 65537 V$ARCHIVE_DEST 4294951386 VIEW 65537 V$BACKUP 4294951076 VIEW 65537 V$BACKUP_CORRUPTION 4294951227 VIEW 65537 V$BACKUP_DATAFILE 4294951225 VIEW 65537 V$BACKUP_DEVICE 4294951382 VIEW 65537 V$BACKUP_PIECE 4294951224 VIEW 65537 V$BACKUP_REDOLOG 4294951226 VIEW 65537 V$BACKUP_SET 4294951223 VIEW 65537 V$BGPROCESS 4294950918 VIEW 65537 V$BH 4294951406 VIEW 65537 V$BUFFER_POOL 4294951393 VIEW 65537 V$CIRCUIT 4294950948 VIEW 65537 V$CLASS_PING 4294951414 VIEW 65537 V$COMPATIBILITY 4294951125 VIEW 65537 V$COMPATSEG 4294951126 VIEW 65537 V$CONTROLFILE 4294951111 VIEW 65537 V$CONTROLFILE_RECORD_SECTION 4294951229 VIEW 65537 V$COPY_CORRUPTION 4294951222 VIEW 65537 V$CURRENT_BUCKET 4294951446 VIEW 65537 V$DATABASE 4294951047 VIEW 65537 V$DATAFILE 4294951050 VIEW 65537 V$DATAFILE_COPY 4294951221 VIEW 65537 V$DATAFILE_HEADER 4294951253 VIEW 65537 V$DBFILE 4294950932 VIEW 65537 V$DBLINK 4294951157 VIEW 65537 V$DB_OBJECT_CACHE 4294951091 VIEW 65537 V$DB_PIPES 4294951143 VIEW 65537 V$DELETED_OBJECT 4294951228 VIEW 65537 V$DISPATCHER 4294950944 VIEW 65537 V$DISPATCHER_RATE 4294951400 VIEW 65537 V$DLM_CONVERT_LOCAL 4294951423 VIEW 65537 V$DLM_CONVERT_REMOTE 4294951425 VIEW 65537 V$DLM_LATCH 4294951420 VIEW 65537 V$DLM_LOCKS 4294951432 VIEW 65537 V$DLM_MISC 4294951418 VIEW 65537 V$ENABLEDPRIVS 4294950942 VIEW 65537 V$ENQUEUE_LOCK 4294951402 VIEW 65537 V$EVENT_NAME 4294951104 VIEW 65537 V$EXECUTION 4294951144 VIEW 65537 V$FILESTAT 4294950934 VIEW 65537 V$FILE_PING 4294951412 VIEW 65537 V$FIXED_TABLE 4294951084 VIEW 65537 V$FIXED_VIEW_DEFINITION 4294951152 VIEW 65537 V$GLOBAL_TRANSACTION 4294951378 VIEW 65537 V$INDEXED_FIXED_COLUMN 4294951151 VIEW 65537 V$INSTANCE 4294951066 VIEW 65537 V$LATCH 4294950921 VIEW 65537 V$LATCHHOLDER 4294950923 VIEW 65537 V$LATCHNAME 4294950922 VIEW 65537 V$LATCH_CHILDREN 4294951168 VIEW 65537 V$LATCH_MISSES 4294951186 VIEW 65537 V$LATCH_PARENT 4294951169 VIEW 65537 V$LIBRARYCACHE 4294950951 VIEW 65537 V$LICENSE 4294951083 VIEW 65537 V$LOADCSTAT 4294950949 VIEW 65537 V$LOADPSTAT 4294951233 VIEW 65537 V$LOADTSTAT 4294950950 VIEW 65537 V$LOCK 4294950927 VIEW 65537 V$LOCKED_OBJECT 4294951181 VIEW 65537 V$LOCKS_WITH_COLLISIONS 4294951410 VIEW 65537 V$LOCK_ACTIVITY 4294951437 VIEW 65537 V$LOCK_ELEMENT 4294951408 VIEW 65537 V$LOG 4294951049 VIEW 65537 V$LOGFILE 4294950935 VIEW 65537 V$LOGHIST 4294951051 VIEW 65537 V$LOG_HISTORY 4294951077 VIEW 65537 V$MTS 4294951093 VIEW 65537 V$MYSTAT 4294951107 VIEW 65537 V$NLS_PARAMETERS 4294951071 VIEW 65537 V$NLS_VALID_VALUES 4294951131 VIEW 65537 V$OBJECT_DEPENDENCY 4294951154 VIEW 65537 V$OFFLINE_RANGE 4294951219 VIEW 65537 V$OPEN_CURSOR 4294951092 VIEW 65537 V$OPTION 4294951133 VIEW 65537 V$PARAMETER 4294950940 VIEW 65537 V$PQ_SESSTAT 4294951138 VIEW 65537 V$PQ_SLAVE 4294951137 VIEW 65537 V$PQ_SYSSTAT 4294951139 VIEW 65537 V$PQ_TQSTAT 4294951190 VIEW 65537 V$PROCESS 4294950917 VIEW 65537 V$PWFILE_USERS 4294951116 VIEW 65537 V$QUEUE 4294950946 VIEW 65537 V$RECENT_BUCKET 4294951448 VIEW 65537 V$RECOVERY_FILE_STATUS 4294951165 VIEW 65537 V$RECOVERY_LOG 4294951078 VIEW 65537 V$RECOVERY_PROGRESS 4294951444 VIEW 65537 V$RECOVERY_STATUS 4294951164 VIEW 65537 V$RECOVER_FILE 4294951075 VIEW 65537 V$REQDIST 4294950947 VIEW 65537 V$RESOURCE 4294950925 VIEW 65537 V$RESOURCE_LIMIT 4294951398 VIEW 65537 V$ROLLSTAT 4294950937 VIEW 65537 V$ROWCACHE 4294950916 VIEW 65537 V$ROWCACHE_PARENT 4294951451 VIEW 65537 V$ROWCACHE_SUBORDINATE 4294951452 VIEW 65537 V$SESSION 4294950919 VIEW 65537 V$SESSION_CONNECT_INFO 4294951259 VIEW 65537 V$SESSION_CURSOR_CACHE 4294951088 VIEW 65537 V$SESSION_EVENT 4294951103 VIEW 65537 V$SESSION_LONGOPS 4294951245 VIEW 65537 V$SESSION_OBJECT_CACHE 4294951376 VIEW 65537 V$SESSION_WAIT 4294951097 VIEW 65537 V$SESSTAT 4294950928 VIEW 65537 V$SESS_IO 4294951080 VIEW 65537 V$SGA 4294950938 VIEW 65537 V$SGASTAT 4294950939 VIEW 65537 V$SHARED_POOL_RESERVED 4294951171 VIEW 65537 V$SHARED_SERVER 4294950945 VIEW 65537 V$SORT_SEGMENT 4294951177 VIEW 65537 V$SORT_USAGE 4294951252 VIEW 65537 V$SQL 4294951148 VIEW 65537 V$SQLAREA 4294951028 VIEW 65537 V$SQLTEXT 4294951090 VIEW 65537 V$SQLTEXT_WITH_NEWLINES 4294951153 VIEW 65537 V$SQL_BIND_DATA 4294951203 VIEW 65537 V$SQL_BIND_METADATA 4294951202 VIEW 65537 V$SQL_CURSOR 4294951201 VIEW 65537 V$SQL_SHARED_MEMORY 4294951194 VIEW 65537 V$STATNAME 4294950930 VIEW 65537 V$SUBCACHE 4294951231 VIEW 65537 V$SYSSTAT 4294950929 VIEW 65537 V$SYSTEM_CURSOR_CACHE 4294951089 VIEW 65537 V$SYSTEM_EVENT 4294951101 VIEW 65537 V$SYSTEM_PARAMETER 4294951200 VIEW 65537 V$TABLESPACE 4294951218 VIEW 65537 V$THREAD 4294951048 VIEW 65537 V$TIMER 4294951068 VIEW 65537 V$TRANSACTION 4294950920 VIEW 65537 V$TRANSACTION_ENQUEUE 4294951404 VIEW 65537 V$TYPE_SIZE 4294951070 VIEW 65537 V$VERSION 4294951045 VIEW 65537 V$WAITSTAT 4294950915 VIEW 65537 V$_LOCK 4294950926 VIEW 65537 V$_LOCK1 4294951065 VIEW 65537 V$_SEQUENCES 4294951182 VIEW 65537 140行が選択されました。