django-\/\/ i K |

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

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

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

event

1.png

该参数一般给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可参考下面链接

实际截图：

2.png

参考连接

http://www.dba-oracle.com/int_event_initialization_parameters.htm

下期参数

shared_pool_size