默认的启动文件是SPFILE,你可以用下面的方式进行更改:
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string %ORACLE_HOME%\DATABASE\SPFILE%
ORACLE_SID%.ORA
SQL> host
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\ora90\bin>cd ..\database
C:\ora90\database>dir *spfile*
Volume in drive C is LOCAL DISK
Volume Serial Number is 321A-1BE5
Directory of C:\ora90\database
2005-09-14 10:41 3,584 SPFILEORA9.ORA
1 File(s) 3,584 bytes
0 Dir(s) 1,965,178,880 bytes free
C:\ora90\database>
C:\ora90\database>exit
SQL> alter system set sql_trace=true scope=spfile;
System altered.
SQL> startup force
ORACLE instance started.
Total System Global Area 160504432 bytes
Fixed Size 453232 bytes
Variable Size 92274688 bytes
Database Buffers 67108864 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> show parameter sql_trace
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sql_trace boolean TRUE
SQL>
如果更改PFILE则需要执行create spfile from pfile;然后再重启实例