我不小心将共享池设成了16M,现在ORACLE不能启动我应该怎么样将加大共享池的大小?
我使用的系统是ORCLE9I+2000SERVER急盼,谢谢
我使用的系统是ORCLE9I+2000SERVER急盼,谢谢
解决方案 »
- 表名中间有小数点
- 求数据同步方案
- 请问Oracle中能定义递归函数吗?
- ORACLE删除大量数据还用清除索引吗?
- 这个sql要怎么写
- PL/SQL问题 DBMS_UTILITY.get_time 可以获得当前时间,但上一天的时间怎么取?
- 怎样知道数据高速缓冲区、字典高速缓冲区、共享sql池、重演日志缓冲区的大小?
- 哪里可以下载pl/sql developer 5.1.3的零售版和注册机
- Nicholaz,谢谢你发的文章,来领分
- 这条SQL为什么执行效率那么低
- 怎么在存储过程里读取读取某个xml文件中的某个节点的值?
- ORACLE 9 数据库redo日志被全部删除了,如何能够重新把数据库启动起来?急!急!急!在线等待……
The size of the reserved list, and the minimum size of the objects that can be allocated from the reserved list, can be controlled by the initialization parameter SHARED_POOL_RESERVED_SIZE. Begin this tuning only after performing all other shared pool tuning. The default value for SHARED_POOL_RESERVED_SIZE is 5% of the SHARED_POOL_SIZE. This means that, by default, the reserved list is always configured. If SHARED_POOL_RESERVED_SIZE > 1/2 SHARED_POOL_SIZE, then Oracle signals an error. Ideally, this parameter should be large enough to satisfy any request scanning for memory on the reserved list without flushing objects from the shared pool. The amount of operating system memory, however, may constrain the size of the shared pool. In general, set SHARED_POOL_RESERVED_SIZE to 10% of SHARED_POOL_SIZE. For most systems, this value is sufficient if you have already tuned the shared pool. If you increase this value, then the database allows fewer allocations from the reserved list and requests more memory from the shared pool list. Statistics from the V$SHARED_POOL_RESERVED view help you tune these parameters. On a system with ample free memory to increase the size of the SGA, the goal is to have REQUEST_MISSES = 0. If the system is constrained for operating system memory, then the goal is to not have REQUEST_FAILURES or at least prevent this value from increasing. If you cannot achieve this, then increase the value for SHARED_POOL_RESERVED_SIZE. Also, increase the value for SHARED_POOL_SIZE by the same amount, because the reserved list is taken from the shared pool. See Also:
For details on setting the LARGE_POOL_SIZE parameter, see Oracle8i Reference.
SHARED_POOL_ RESERVED_SIZE Too Small
The reserved pool is too small when the value for REQUEST_FAILURES is more than zero and increasing. To resolve this, increase the value for the SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE accordingly. The settings you select for these depend on your system's SGA size constraints. This option increases the amount of memory available on the reserved list without having an effect on users who do not allocate memory from the reserved list. As a second option, reduce the number of allocations allowed to use memory from the reserved list; however, doing so increases the normal shared pool, which may have an effect on other users on the system. SHARED_POOL_ RESERVED_SIZE Too Large
Too much memory may have been allocated to the reserved list if: REQUEST_MISS = 0 or not increasing FREE_MEMORY = > 50% of SHARED_POOL_RESERVED_SIZE minimum If either of these is true, then decrease the value for SHARED_POOL_RESERVED_SIZE.
我通过搜索ORACLE目录SHARED_POOL_RESERVED_SIZE找到一个文件
d:\orcle\ora92\database\SPFILEWRLDB.ORA
里面原来的SHARED_POOL_RESERVED_SIZE字段很大(我本来设为16M的,不知为何变为12???????这么大)我将它设为6000后就可以启动 了