Database Tuning (MOSC)

MOSC Banner

Library cache wait events

edited Apr 6, 2017 5:01AM in Database Tuning (MOSC) 9 commentsAnswered
 Hi,

We are facing performance issue for our DB system. In the AWR report, i can see 

library cache lock,
DB CPU,
SQL*Net more data to client,
library cache pin,
db file sequential read 

as the top wait events.  I would request, you can get help in analyzing the Library cache wait events. To add, do excess size of shared pool can be one the reason.

Please let update, if needed more details.

Thanks. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center