Database Administration (MOSC)

MOSC Banner

How can i force specific ORA- errors to be written to the alert.log?

edited May 13, 2016 12:05PM in Database Administration (MOSC) 4 commentsAnswered ✓

the background is, I needed modify a user profile and restrict the limits CPU_PER_CALL and LOGICAL_READS_PER_CALL.

Whenever such a users query hits one of these limits, he get the messages: "ORA-02393: exceeded call limit on CPU usage" or "ORA-02395: exceeded call limit on IO usage"

Both error messages don't appear in the alert.log

For fine-tuning the restrictions, I need to know, how often a user hits these limits.

How can I count the occurrence of these errors without the overhead of tracing all user sessions?

regards

Dieter

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