Oracle Ebs-sql (SYS-13): Queries the DBA for patching information in the system. SQL

Query DBA's patching information in the system

1. Select * FROM Ad_patch_drivers/* To see which patch*/have been hit

2. Select * FROM Ad_patch_runs/* View the time of patch, directory and other information * *

3. Select * FROM ad_patch_driver_langs/* View Patch language */

4. Query the patch name, language, start time of patch, Patch completion time:

SELECT driver.driver_file_name Patch Name,

Lang.language language,

To_char (run.start_date, ' Rrrr-mm-dd HH24:MI:SS ') Start time,

To_char (run.end_date, ' rrrr-mm-dd HH24:MI:SS ') Completion time

From Ad_patch_runs Run,

Ad_patch_driver_langs Lang,

Ad_patch_drivers driver,

Ad_applied_patches applied

WHERE run.patch_driver_id = driver.patch_driver_id

and driver.applied_patch_id = applied.applied_patch_id

and lang.patch_driver_id = driver.patch_driver_id ORDER by 3,4,1,2

-You can count the time of patch, which is helpful to the time and schedule of patches for the product environment.