打开WINDOWS 2000 SERVER的命令提示行(CMD)
C:\IPCS -m
IPC status from HAPPYSOFT as of Fri Dec 3 23:08:58 2004
T ID KEY MODE OWNER GROUP
Shared Memory:就像你说的:找到Oracle为OWNER的行,记下ID号
再用ipcrm -m ID 最后重启Oracle。”
C:\IPCS -m
IPC status from HAPPYSOFT as of Fri Dec 3 23:08:58 2004
T ID KEY MODE OWNER GROUP
Shared Memory:就像你说的:找到Oracle为OWNER的行,记下ID号
再用ipcrm -m ID 最后重启Oracle。”
alter system flush shared_pool;
You cannot change SPFILE using editor.
You have first to change the parameters in pfile and to bounce Oracle explicitely pointing the pfile:STARTUP PFILE = /u01/oracle/dbs/init.ora
After that you can edit the spfile ALTER SYSTEM set open_cursors=400 SCOPE =spfile;
open_cursors=400 is only an example of a parameter.
命令提示行(CMD)
C:\IPCS -m
IPC status from HAPPYSOFT as of Fri Dec 3 23:08:58 2004
T ID KEY MODE OWNER GROUP
Shared Memory:就像你说的:找到Oracle为OWNER的行,记下ID号
再用ipcrm -m ID 最后重启Oracle。”
我执行了提示找不到命令行