Hi Ggnanaraj,

I really appreciate ur time.

But my observation is, in Oracle documentation it is not very much clear how to interpret statistics on Latch and wait and Event.

I am interested to know what role does latch play in database? When should I look into those Latches , events and Waits. And very much would like to know how to interpret statistics.

Is there any other tuning scripts or monitoring scripts available? Is there any other documents that help me to interpret their statistics?

Regards