데이터파일, 테이블스페이스 정보 확인 SQL

backup
set linesize 150
set pagesize 50
col name for a40
col file# for 999,999
col status for a15
col time for a20

select a.file#, a.name, b.status, to_char(b.time,'RRRR-MM-DD:HH24:MI:SS') as time
from v$datafile a, v$backup b
where a.file#=b.file#;
datafile
set linesize 150
set pagesize 50
col tablespace_name for a20
col mb for 999,999
col status for a10
col file_name for a40

select tablespace_name, bytes/1024/1024 mb, status, file_name
from dba_data_files
order by 4;
테이블스페이스
set linesize 150
set pagesize 50

col tablespace_name for a20
col status for a10
col contents for a20
col segment_space_management for a15
col extent_management for a15

select tablespace_name, status, contents, segment_space_management, extent_management
from dba_tablespaces;
로그파일
set linesize 150
set pagesize 50

col group# for 999
col member for a40
col mb for 9,999,999
col status for a10
col archived for a10
col sequence# for 9,999,999

select a.group#, b.member, a.bytes/1024/1024 MB, a.status, a.archived, a.sequence#
from v$log a, v$logfile b
where a.group#=b.group#
order by 1,2;
템프파일
set linesize 200
set pagesize 50

col tablespace_name for a25
col mb for 999,999,999
col file_name for a50


select tablespace_name, bytes/1024/1024 mb, file_name
from dba_temp_files

You may also like...

1 Response

  1. 준원 댓글:

    형 퍼가요~ 감솨~
    근데 이거 긁으니까 모양 그대로 복사가 되네요
    네이버에서도 되나보네요~

준원에 답글 남기기 응답 취소

이메일 주소는 공개되지 않습니다. 필수 필드는 *로 표시됩니다