문서의 이전 판입니다!

잡다한 내용들

생성시간

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%';

패치 및 버젼상태확인 (9i 이상)

SQL> SELECT comp_name, version, STATUS FROM dba_registry;
 
COMP_NAME                      VERSION         STATUS
------------------------------ --------------- ----------------------
Oracle Enterprise Manager      10.2.0.1.0      VALID
Spatial                        10.2.0.1.0      VALID
Oracle interMedia              10.2.0.1.0      LOADING
OLAP Catalog                   10.2.0.3.0      VALID
Oracle XML DATABASE            10.2.0.3.0      VALID
Oracle Text                    10.2.0.3.0      VALID
Oracle Expression FILTER       10.2.0.1.0      VALID
Oracle Rules Manager           10.2.0.1.0      VALID
Oracle Workspace Manager       10.2.0.1.0      VALID
Oracle DATA Mining             10.2.0.3.0      VALID
Oracle DATABASE Catalog Views  10.2.0.3.0      VALID
Oracle DATABASE Packages AND T 10.2.0.3.0      VALID
ypes
JServer JAVA Virtual Machine   10.2.0.3.0      VALID
Oracle XDK                     10.2.0.3.0      VALID
Oracle DATABASE Java Packages  10.2.0.3.0      VALID
OLAP Analytic Workspace        10.2.0.3.0      VALID
Oracle OLAP API                10.2.0.3.0      VALID
 
17 ROWS selected.