Oracle tables that store patch information

Oracle has suggested Patch 5087017 in its metalink note. We need to check whether the patch has been applied in our Oracle instance or not.

Since the patch suggested by Oracle in the metalink note above, is an one-off patch we need to check the table AD_BUGS to see if the patch has been applied or not. Run the following query

1 2 3 4

-- For single patch application SELECT *   FROM ad_bugs  WHERE bug_number = '5097017'   -- Oracle patch number

Since we get 1 row in the table using the bug_number or patch number we get to know that the patch has been applied on 12-Jun-2011 (entry in CREATION_DATE column).

For Family pack patches check the table, AD_APPLIED_PATCHES. In this table you will find entries for all the family patch applications.

1 2 3

-- For family package application SELECT *   FROM ad_applied_patches

Cheers!