ITPub博客

首页 > Linux操作系统 > Linux操作系统 > DUMP备忘录(-)

DUMP备忘录(-)

原创 Linux操作系统 作者:vongates 时间:2019-06-18 21:06:06 0 删除 编辑

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博客 ” ,链接:http://blog.itpub.net/29987/viewspace-51620/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-09-11

  • 博文量
    448
  • 访问量
    290371