Queryable Patch Inventory

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