GaramX

1.DB 사용자 알아보기.

SELECT username, account_status FROM dba_users WHERE username='SCOTT';

2.TableSpace목록보기 SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM DBA_TABLESPACES;

select name from v$controlfile; select file_name from dba_data_files; select group#,member from v$logfile;