Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, David.

Asked: October 29, 2019 - 3:26 pm UTC

Last updated: November 05, 2019 - 4:12 am UTC

Version: 18

Viewed 1000+ times

You Asked


Hello Masters,

Can you give me a link on docs.oracle.com where are listed all the system event codes for the trace like 10046, 10053... and, most important, with there signification?

I know the 10046, 10053 codes but I am sure there are many manu others.

Have a nice day.

David D. from Paris/France

and Connor said...

There are not documented because they are called "undocumented" for a reason :-)

However, if you look at $ORACLE_HOME/rdbms/mesg/oraus.msg you can see a listing of them.

But I cannot stress this highly enough:

- not supported, not documented, etc etc etc
- events can very destructive, you could destroy a database if used incorrectly.

If you play with fire...typically you'll get burnt.

You won't get any support from Support if you make a mess of things...

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

David DUBOIS, October 31, 2019 - 10:46 am UTC

Hello Connor,

Thank you for the response. I didn't know that the traces 10046, 10053 for exemple where undocumented features. I use the trace 10046 so many times, I read so many books with exemples about them... And I thought that trace on event system were like a simple SELECT : you can't damage the database!

Apparently it is not the case like you say.

Last thing, there are so many system event code in this file, can you tell me which events you use frequently to tune a database, Chris and the others experts?

Have a nice day,

David D From Paris/FRANCE

Connor McDonald
November 01, 2019 - 1:09 am UTC

David DUBOIS, November 01, 2019 - 7:20 am UTC

One time again : excellent response :-)

Connor McDonald
November 05, 2019 - 4:12 am UTC

Glad we could help

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database