When startup database:
SYS@orcl> startup
ORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE 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:
- SQL_TRACE
-
Property Description
-
Parameter type Boolean
-
Default value false
-
Modifiable ALTER SESSION, ALTER SYSTEM
-
Range of values true | false
-
-
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.
-
-
Caution:
-
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:
-
-
*Maintaining at least 25% idle CPU capacity
-
*Maintaining adequate disk space for the USER_DUMP_DEST location
-
*Striping disk space over sufficient disks
-
-
See Also:
-
Oracle Database Performance Tuning Guide for more information about performance diagnostic tools
-
-
Note:
-
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) |