shared_pool_size值一般设置为物理内存的5%
ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0
SQL> startup nomount; ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0 SQL> create pfile = '/se/2014_2_22_1.ora' from spfile; File created. SQL> !echo '*.shared_pool_size=100M' >>'/se/2014_2_22_1.ora'; SQL> create spfile from pfile = '/se/2014_2_22_1.ora'; File created. SQL> startup nomount; ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0 SQL> exit Disconnected [oracle@Znotz ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.2.0 - Production on Sat Feb 15 22:13:34 2014 Copyright (c) 1982, 2005, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup nomount; ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started. Total System Global Area 348127232 bytes Fixed Size 1260756 bytes Variable Size 268436268 bytes Database Buffers 71303168 bytes Redo Buffers 7127040 bytes
----------------------------------------------------------------------------------------------
版权所有,如需转载,请注明出处,否则追加法律责任!
blog:http://blog.csdn.net/waycomecome
sga_target或shared_pool_size非正常值导致ORA-00093解决办法
最新推荐文章于 2022-11-08 17:37:46 发布