Oracle tracks common internal event numbers

Oracle tracks common internal event numbers

Oracle internal event numbers are often used to track the system status. How to use these internal event numbers requires events and experience. Only these commonly used internal event numbers are recorded here for work preparation.

1. 10013: used to monitor transaction recovery
2. 10015: dump the undo segment Header
Event = "10015 trace name context forever"
3. 10029: used to provide login information during the session
4. 10030: used to provide logout information during the session
5. 10032: Dump sorting statistics
6. 10033: dump the statistics of sort Growth
7. 10045: Tracking Freelist management operations
8. 10046: Tracking SQL statements
Alter session set events '2017 trace name context forever, level 4'; -- trace SQL statements and display Bound variables
Alter session set events '2014 trace name context forever, level 8'; -- trace SQL statements and display wait events
9. 10053: Dump optimization policy
10. 10059: Create and clear errors in the simulated redo log
11. 10061: prevents the SMON process from clearing the temporary segment at startup
12. 10079: dumping SQL * NET statistics
13. 10081: dump high-water mark changes
14. 10104: Dump Hash connection statistics
15. 10128: Dump partition rest Information
16. 10200: Dump consistent read information
17. 10201: dumping Undo applications in consistent read
18. 10209: Allow simulating errors in the control file
19. 10210: trigger the data block check event
Event = "10210 trace name context forever, level 10"
20. 10211: Index check event triggered
21. 10213: simulate a crash after the write control file
22. 10214: Simulate write errors in the control file
Levelnumber from 1 to 9 indicates that an incorrect block number is generated. If it is greater than or equal to 10, an error occurs for each control file.
23. 10215: simulate a read error in the control file
24. 10220: Dump Undo header changes
25. 10221; dump Undo changes
26. 10224: Separation and deletion of dump Indexes
27. 10225: Dump dictionary-based interval changes
28. 10229: Simulate I/O errors on data files
29. 10231: Set to ignore damaged data blocks during full table Scan
Alter session set events '10231 trace name context off'; -- disable data block check during the session
Event = "10231 trace name context forever, level 10" -- check the data blocks read by any process into SGA.
30. 10232: dumps data blocks that are set to soft-corruption (when DBMS_REPAIR package is set or DB_BLOCK_CHECKING is set to TRUE) to the trace file.
31. 10235: used for memory heap check
Alter session set events '10235 trace name context forever, level 1 ';
32. 10241: dumping Remote SQL Execution
33. 10246: Tracking PMON Processes
34. 10248: trace the dispatch Process
35. 10249: Tracking MTS Processes
36. 10252: simulate a data file header error
37. 10253: Simulate an error in writing a redo log file
38. 10262: Memory leakage is allowed during connection
Alter session set events '2014 trace name context forever, level 100'; -- 10262 bytes of Memory leakage is allowed
39. 10270: Dump shared cursor
40. 10285: the head of the simulated control file is damaged.
41. 10286: simulated control file opening Error
42. 10287: Simulated archiving Error
43. 10357: debug the direct path Mechanism
44. 10500: trace the SMON Process
45. 10608: Tracking the creation of Bitmap indexes
46. 10704: Tracking enqueues
47. 10706: tracking global enqueues
48. 10708: trace the RAC buffer cache
49. 10710: Tracking access to Bitmap indexes
50. 10711: Tracking bitmap index merge operations
51. 10712: Tracking bitmap index OR operations
52. 10713: Tracking Bitmap indexes AND operations
53. 10714: trace bitmap index MINUS operations
54. 10715: Tracking bitmap index conversion to ROWID
55. 10716: Tracking the compression and decompression of Bitmap indexes
56. 10719: Tracking the modification of Bitmap indexes
57. 10731: Tracking cursor Declaration
58. 10928: trace PL/SQL Execution
59. 10938: dumping PL/SQL Execution statistics