오라클 utlrp, catproc 실행 기록 확인 방법

OS환경 : Oracle Linux 8.1 (64bit)

DB 환경 : Oracle Database 19.3.0.0

방법 : 오라클 utlrp, catproc 실행 기록 확인 방법

DBA_REGISTRY_LOG 뷰 확인

SQL>
set lines 200
set pages 1000
col optime for a40
col message for a40
select * from DBA_REGISTRY_LOG;
 
OPTIME                                   NAMESPACE                      COMP_ID                        OPERATION   MESSAGE
---------------------------------------- ------------------------------ ------------------------------ ----------- ----------------------------------------
07-JAN-20 01.05.49.632573 AM             SERVER                         CATPROC                        LOADED      19.3.0.0.0
07-JAN-20 01.13.02.371668 AM             SERVER                         UTLRP_BGN                      START
07-JAN-20 01.13.10.506973 AM             SERVER                         UTLRP_END                      START
09-FEB-20 11.29.07.147741 PM             SERVER                         UTLRP_BGN                      START
09-FEB-20 11.29.12.499642 PM             SERVER                         UTLRP_END                      START
09-FEB-20 11.37.54.163097 PM             SERVER                         UTLRP_BGN                      START
09-FEB-20 11.37.58.572472 PM             SERVER                         UTLRP_END                      START
10-FEB-20 12.33.19.625682 AM             SERVER                         CATPROC                        LOADED      19.3.0.0.0
 
8 rows selected.

utlrp.sql은 시작시간과 끝난시간이 나오지만

catproc.sql은 끝난시간만 표시됨

DBA_REGISTRY_LOG 뷰는 10gR2부터 사용할 수 있음

9.2.0.4~ 18.3.0.0까지 실행 결과

9.2.0.4
SQL> select * from DBA_REGISTRY_LOG;
              *
ERROR at line 1:
ORA-00942: table or view does not exist
 
10.2.0.4
SQL> select * from DBA_REGISTRY_LOG;
OPTIME                     NAMESPACE            COMP_ID                OPERATION   MESSAGE
---------------------------------------- ------------------------------ ----------------------
10-FEB-20 12.16.39.887033 PM         SERVER             UTLRP_BGN
10-FEB-20 12.16.40.287379 PM         SERVER             UTLRP_END
 
11.2.0.4
SQL> select * from DBA_REGISTRY_LOG;
OPTIME                     NAMESPACE            COMP_ID                OPERATION   MESSAGE
---------------------------------------- ------------------------------ ------------------------------ -----------
15-OCT-19 09.20.00.371278 AM         SERVER             CATPROC                VALID       11.2.0.4.0
10-FEB-20 09.17.00.724674 PM         SERVER             UTLRP_BGN               START
10-FEB-20 09.17.01.305855 PM         SERVER             UTLRP_END               START
 
12.2.0.1
SQL> select * from DBA_REGISTRY_LOG;
OPTIME                     NAMESPACE            COMP_ID                OPERATION   MESSAGE
---------------------------------------- ------------------------------ ------------------------------ -----------
15-OCT-19 01.06.12.770853 AM         SERVER             CATPROC                INVALID       12.2.0.1.0
15-OCT-19 01.08.30.792014 AM         SERVER             UTLRP_BGN               START
15-OCT-19 01.08.35.867157 AM         SERVER             UTLRP_END               START
 
18.3.0.0
SQL> select * from DBA_REGISTRY_LOG;
OPTIME                     NAMESPACE            COMP_ID                OPERATION   MESSAGE
---------------------------------------- ------------------------------ ------------------------------ -----------
15-OCT-19 10.12.33.430592 AM         SERVER             CATPROC                LOADED       18.3.0.0.0
15-OCT-19 10.19.16.599828 AM         SERVER             UTLRP_BGN               START
15-OCT-19 10.19.22.372928 AM         SERVER             UTLRP_END               START

참조 : 

https://positivemh.tistory.com/107