Re: Comparison between Quest CENTRAL and VERITAS indepth Oracle

dominica_at_gmail.com wrote:
> I kind of feel it is that process, there are multiple of those
> processes running . But I have trouble narrow down
> what thing to remedies this situation.
> I already look at the V$latches and found there is no
> contection in the latch.
>
> I am new to these 2 databases, I just start this job recently.

My advice ... you need to understand what those applications are doing, how they are designed, why they are designed that way, if they are designed at all ... etc. Products like they ones you mentioned won't help there.

Has someone asked you to look into this or are you just curious? Is there a specific business problem you are trying to solve?

There are low level traces that can be activated which will show you exactly what these processes are doing. Cary Millsap has an excellent book that you may want to look at.

Of course oracle has tools that will help in this discovery process also that you definitely want to look at before deciding looking at anything real low level.

Start talking to the programmers familiar with the applications. Then people familiar with how shop operates. Has it always been like this? What changed and when? Yada yada yada Received on Fri Apr 29 2005 - 17:58:09 CDT