Chinaunix首页 | 论坛 | 博客
  • 博客访问: 217985
  • 博文数量: 57
  • 博客积分: 1376
  • 博客等级: 中尉
  • 技术积分: 658
  • 用 户 组: 普通用户
  • 注册时间: 2010-05-09 09:51
文章分类

全部博文(57)

文章存档

2012年(1)

2011年(56)

分类: Oracle

2011-04-04 20:55:45

When startup database:
SYS@orcl> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  595591168 bytes
Fixed Size                  1220748 bytes
Variable Size             188747636 bytes
Database Buffers          398458880 bytes
Redo Buffers                7163904 bytes
Database mounted.
Database opened.

I doubt that if there is some parameter in spfile is deprecated!
After checking the spfile, I found sql_trace must be the root cause.

After reset this parameter, the error note not show:
SYS@orcl> alter system reset sql_trace scope=spfile sid='*' ;

System altered.

SYS@orcl> startup force
ORACLE instance started.

Total System Global Area  595591168 bytes
Fixed Size                  1220748 bytes
Variable Size             192941940 bytes
Database Buffers          394264576 bytes
Redo Buffers                7163904 bytes
Database mounted.
Database opened.


And then I looked up the documentation:
  1. SQL_TRACE
  2. Property Description
  3. Parameter type Boolean
  4. Default value false
  5. Modifiable ALTER SESSION, ALTER SYSTEM
  6. Range of values true | false

  7. SQL_TRACE enables or disables the SQL trace facility. Setting this parameter to true provides information on tuning that you can use to improve performance. You can change the value using the DBMS_SYSTEM package.

  8. Caution:
  9. Using this initialization parameter to enable the SQL trace facility for the entire instance can have a severe performance impact. Enable the facility for specific sessions using the ALTER SESSION statement. If you must enable the facility on an entire production environment, then you can minimize performance impact by:

  10. *Maintaining at least 25% idle CPU capacity
  11. *Maintaining adequate disk space for the USER_DUMP_DEST location
  12. *Striping disk space over sufficient disks

  13. See Also:
  14. Oracle Database Performance Tuning Guide for more information about performance diagnostic tools

  15. Note:
  16. This parameter is deprecated. Oracle recommends that you use the DBMS_MONITOR and DBMS_SESSION packages instead. SQL_TRACE is retained for backward compatibility only.

So this parameter will affect the server performance, Oracle deprecated it, instead, DBMS_MONITOR and DBMS_SESSION are recomend to use.

阅读(2447) | 评论(0) | 转发(0) |
0

上一篇:Oracle 10g RAC on RHEL5

下一篇:获奖感言

给主人留下些什么吧!~~