Oracle Database Discussions

Hi PT Experts,

I need to understand on this parameter. Whenever I see this event , Users start complaining about this slowness.

Definition : This latch protects the access of the data dictionary cache in
the SGA. When loading, referencing and freeing objects in the
data dictionary cache you need to get this latch.


I see whenever in one of the table inserts and updates are going on , this event occur. Can there we problem with that particular table ? We face this issue generally during some specific time.

Is that possible we may have issue with Shared_pool ?

Is that possible that lots of active sql are running , congestion in shared pool ?

Generally Suggestion Increased the share pool. From which I understand lots of active sessions and shared pool is fully consumes and new session is waiting on Latch for row cache. Respective object may or may not be in pool.

I dont know how much correct I am.

Please update.

Regards
Sourabh Gupta