Skip to Main Content

Breadcrumb

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Question and Answer

Connor McDonald

Thanks for the question, David.

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

Answered by: Connor McDonald - Last updated: November 05, 2019 - 4:12 am UTC

Category: Database Administration - Version: 18

Viewed 100+ times

Whilst you are here, check out some content from the AskTom team: FORALL and ROLLBACKs

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 we 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...

and you rated our response

  (2 ratings)

Reviews

October 31, 2019 - 10:46 am UTC

Reviewer: David DUBOIS

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

Followup  

November 01, 2019 - 1:09 am UTC

Julian Dyke has a great site for this

http://www.juliandyke.com/Diagnostics/Events/EventReference.php

November 01, 2019 - 7:20 am UTC

Reviewer: David DUBOIS

One time again : excellent response :-)

Connor McDonald

Followup  

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