Database Administration (MOSC)

MOSC Banner

Monitoring SGA utilization

Is there anyway I could schedule a job or is there any scripts which I could scheduled into the scheduler to collect SGA utilization on an hourly basis?

I'm having some very weird behaviour on my production databases where the application disconnects almost daily at a certain time of a day. I cannot pin point which script was run during the time when disconnection occurs as it's different everytime.

I do notice that whenever application connection disconnected from the DB, I see an abnormally high latch: shared_pool waits from the AWR. Multiple tickets has been raised to MOS but yield no results at all. This is because there is no error detected in either the DB alert logs or even listener logs. Application logs only says connection to DB lost.

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