Oracle 12c부터는 DBMS_QOPATCh package를 통해서 sqlplus 상에서 patch 정보를 확인할 수 있답니다..
Database node가 많은 RAC 환경에서는 편할 수 있겠네요..
Queryable Patch Inventory
Using DBMS_QOPATCH
, Oracle Database 12c provides a PL/SQL or SQL interface to view the database patches that are installed. The interface provides all the patch information available as part of the OPatch lsinventory -xml
command. The package accesses the Oracle Universal Installer (OUI) patch inventory in real time to provide patch and patch meta information.
Using this feature, users can:
Query what patches are installed from SQL*Plus.
Write wrapper programs to create reports and do validation checks across multiple environments.
Check patches installed on Oracle RAC nodes from a single location instead of having to log onto each one in turn.
See Also:
Oracle Database PL/SQL Packages and Types Reference for details
'Oracle Database > Oracle New Features' 카테고리의 다른 글
Tom Kyte 가 소개하는 Oracle 12c Net Features 12개 (0) | 2014.12.15 |
---|---|
Oracle 12c New feature : enhanced Upgrade Automation & parallel upgrade (0) | 2014.11.11 |
12c Hybrid Hash Distribution with Skew Detection / Handling (0) | 2014.05.20 |
Oracle 12c RMAN New feature : Table Recovery (0) | 2013.12.13 |
Oracle Database 12c의 소소한 feature. (0) | 2013.12.13 |