문서의 이전 판입니다!

잡다한 내용들

생성시간

SQL> SELECT * FROM dba_objects WHERE object_type = 'INDEX' AND owner='BEFLYDBA' ORDER BY created DESC

oradebug

SQL> oradebug setmypid
SQL> oradebug ipc
SQL> oradebug tracefile_name

INDEX 컬럼

SQL> SELECT * FROM user_ind_columns WHERE index_name LIKE 'DR%';

adminschool.net wiki