필수로 암기해야 할 view 들...
2010.05.12 08:18
원문 : http://www.ischo.net -- 조인상 // 시스템 엔지니어
Writer : http://www.ischo.net -- ischo // System Engineer in Replubic Of Korea
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
본문 : http://www.ischo.net -- 조인상 //시스템 엔지니어
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
1. mount 단계에서 조회가능
v$datafile
sql> SELECT name,status FROM v$datafile;
v$controlfile
sql> SELECT name FROM v$controlfile;
v$logfile
sql> SELECT member FROM v$logfile;
datafile과 해당하는 테이블스페이스 조회
sql> SELECT t.name tablespace, f.name datafile
2> FROM v$tablespace t, v$datafile f
3> WHERE t.ts# = f.ts#
4> ORDER BY datafile;
2. open 단계에서 조회가능
DBA_DATA_FILES
sql> SELECT file_name, tablespace_name FROM dba_data_files;
DBA_TABLESPACES
sql> SELECT tablespace_name, status FROM dba_tablespaces;