URGENT - LATCH MISSES ON PRODUCTION - PERF DOWN

[nabaig]

Gents,

Need a reply as how to fix latch misses. Performance is down on my production database.

Thanks,
Nizar

[jdorlon]

Nizar,

If you have Metalink access, follow this link :

http://metalink.oracle.com/metalink/...T&p_id=62161.1

It has very good information about many wait events,
and what to do about them. Look for 'latch free'.

-John