Re: difference between ad_bugs -ad_applied_patches
- From: "sridhar rao" <drmsr6@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Thu, 2 Aug 2007 13:53:51 +0530
great.good analytical note.thanks jurijs
On 8/2/07, Jurijs Velikanovs <j.velikanovs@xxxxxxxxx> wrote:
> 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:
