Source of Oracle参数解析(event)

  前面介绍了Oracle的基本参数，从这节开始讲其他的参数，参数从v$parameter中提取

基本参数请看如下链接:
[http://www.zhaibibei.cn/oralce/oracle-parameter/](http://www.zhaibibei.cn/oralce/oracle-parameter/)

如无特殊说明数据库版本为11.2

-------

**event**




[image:183 size:orig]








该参数一般给Oracle Support用来做特殊用途使用的

如10053事件  10046事件等

他可以开启更多的trace或排错功能

可以使用如下命令在参数文件中设定

```
EVENT="<event 1>:<event 2>: <event 3>: <event n>"
```

也可以换行指定
```
EVENT="\
10210 trace name context forever, level 10:\
10211 trace name context forever, level 10:\
10231 trace name context forever, level 10:\
10232 trace name context forever, level 10"\ 
```

生效需重新启动数据库


一些事件我们可以在session级别指定


-----

**一些常用的事件event**


In order to trace a MAX_CURSORS exceeded error:

    event="1000 trace name ERRORSTACK level 3"


To get an error stack related to a SQLNET ORA-03120 error:

    event="3120 trace name error stack"

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 enable the maximum level of SQL performance monitoring:

    event = "10046 trace name context forever, level 12"



更多event可参考下面链接


--------


**实际截图：**


[image:184]







-----

参考连接

[http://www.dba-oracle.com/int_event_initialization_parameters.htm](http://www.dba-oracle.com/int_event_initialization_parameters.htm)


----------

下期参数

**shared_pool_size**
Oracle参数解析(event) event
