読者です 読者をやめる 読者になる 読者になる

onox developer blog

developerman

Oracle12c パラメータ確認用のSQL

memo

SELECT SUBSTR(COMP_NAME,1,40) AS name,SUBSTR(VERSION,1,10) AS ver,SUBSTR(STATUS,1,10) AS status FROM DBA_REGISTRY ORDER BY 1;
select username,ACCOUNT_STATUS,LOCK_DATE from dba_users;
show parameter spfile
show parameter BACKGROUND_DUMP_DEST
show parameter COMPATIBLE
show parameter CONTROL_FILES
show parameter CORE_DUMP_DEST
show parameter DB_BLOCK_SIZE
show parameter DB_CACHE_SIZE
show parameter DB_NAME
show parameter EVENT
show parameter INSTANCE_NAME
show parameter LOG_ARCHIVE_START
show parameter LOG_CHECKPOINT_INTERVAL
show parameter LOG_CHECKPOINT_TIMEOUT
show parameter MEMORY_TARGET
show parameter PGA_AGGREGATE_TARGET
show parameter PROCESSES
show parameter QUERY_REWRITE_ENABLED
show parameter SERVICE_NAME
show parameter SGA_TARGET
show parameter STATISTICS_LEVEL
show parameter UNDO_MANAGEMENT
show parameter UNDO_RETENTION
show parameter UNDO_TABLESPACE
show parameter USER_DUMP_DEST
show parameter LOG_ARCHIVE_START
show parameter LOG_ARCHIVE_DEST
show parameter LOG_ARCHIVE_FORMAT
show parameter MEMORY_TARGET
select * from v$controlfile;
select TABLESPACE_NAME,BLOCK_SIZE,INITIAL_EXTENT,NEXT_EXTENT from dba_tablespaces;
select TABLESPACE_NAME,MIN_EXTENTS,MAX_EXTENTS,MAX_SIZE from dba_tablespaces;
select TABLESPACE_NAME,PCT_INCREASE,CONTENTS,LOGGING from dba_tablespaces;
select TABLESPACE_NAME,EXTENT_MANAGEMENT,ALLOCATION_TYPE,SEGMENT_SPACE_MANAGEMENT from dba_tablespaces;
select FILE_NAME,FILE_ID,TABLESPACE_NAME,BYTES from dba_data_files;
select FILE_NAME,BLOCKS,AUTOEXTENSIBLE,MAXBYTES,MAXBLOCKS,INCREMENT_BY from dba_data_files;
select * from  v$tempfile;
select FILE_NAME,FILE_ID,TABLESPACE_NAME,BYTES from dba_data_files;
select FILE_NAME,BLOCKS,AUTOEXTENSIBLE,MAXBYTES,MAXBLOCKS,INCREMENT_BY from dba_data_files;
select * from  v$tempfile;
select * from v$logfile;
select * from v$log;
show parameters BACKGROUND_DUMP_DEST;
show parameters CORE_DUMP_DEST;
ARCHIVE LOG LIST
select RECID,FIRST_TIME,COMPLETION_TIME,NAME from V$ARCHIVED_LOG;
select * from v$log;
ALTER SYSTEM SWITCH LOGFILE;
select * from v$log;
select RECID,FIRST_TIME,COMPLETION_TIME,NAME from V$ARCHIVED_LOG;