Monitoring and Tuning Latch,Wait and Event
Hi Experts
I would like to monitor and tune my Database Latch, Event and Waits. I would like to do the same from production database point of view.
Can anybody please help me with what type of monitoring script is required for the same?
What are the tables I have to look into?
When I have to monitor or tune those?
What kind of promlems I will face with these?
You can give me any reference document or thread. I will go thru that too.
I appreciate or time in advance
Regards
Re: Monitoring and Tuning Latch,Wait and Event
Quote:
Originally posted by sumit
I would like to monitor and tune my Database Latch, Event and Waits.
http://download-west.oracle.com/docs...tune.htm#18211
HTH.