Re: difference between ad_bugs -ad_applied_patches
- From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Thu, 2 Aug 2007 11:14:10 +0300
Hi there,
It is just a quick idea. I have suspicious that ad_applied_patches
contains information about patches that you applied on the system,
ad_bugs has information about all bugs and patches that have been
included in the patches you applied.
For example you apply merged patch merge123 it contains 5 patches
10001 10002 10003 …
ad_applied_patches – will have one record about merge123
ad_bugs – 5 records
Another example: you apply maintenance patch which includes 51 other
patches. In that case
ad_applied_patches – will have one record about maintenance patch
ad_bugs – 51 + 1
I hope my thought is clear for you.
PS Anyway I use ad_bugs table in order to find out do I have one or
another patch to apply.
Jurijs
On 8/2/07, sridhar rao <drmsr6@xxxxxxxxx> wrote:
> Hi DBA'S
> can u explain difference between ad_bugs and ad_applied_patches(which
> is asked recently.
> thanks in advance
> sridhar.m
>
>
--
Yury
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
Other related posts:
