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