The following undocumented SQL statements can be used to obtain information about internal database structures:
To dump the control file:
alter session set events 'immediate trace name CONTROLF level 10'
To dump the file headers:
alter session set events 'immediate trace name FILE_HDRS level 10'
To dump redo log headers:
alter session set events 'immediate trace name REDOHDR level 10'
To dump the system state:
alter session set events 'immediate trace name SYSTEMSTATE level 10'
To dump the optimizer statistics whenever a SQL statement is parsed:
alter session set events '10053 trace name context forever'
To prevent db block corruptions:
event = "10210 trace name context forever, level 10"
event = "10211 trace name context forever, level 10"
event = "10231 trace name context forever, level 10"
To enable the maximum level of SQL performance monitoring:
event = "10046 trace name context forever, level 12"
To enable a memory-protect cursor:
event = "10049 trace name context forever, level 2"
To perform data-block checks:
event = "10210 trace name context forever, level 2"
To perform index-block checks:
event = "10211 trace name context forever, level 2"
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29987/viewspace-51620/ ，如需转载，请注明出处，否则将追究法律责任。
