large_pool_size不能超过shared_pool_size

The large pool must be explicitly configured. The memory of the large pool does

not come out of
the shared pool, but directly out of the SGA, thus adding to the amount of shared

memory the
Oracle server needs for an instance at startup

[@more@]

--===========================
SQL> show parameter large

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
large_pool_size big integer 0
SQL> show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 160M
sga_target big integer 160M
SQL> alter system set large_pool_size=100m;
alter system set large_pool_size=100m
*
第 1 行出现错误:
ORA-02097: 无法修改参数, 因为指定的值无效
ORA-04033: 没有足够的内存来增加池的容量

SQL> alter system set sga_max_size=260m scope=spfile;

系统已更改。

SQL> alter system set large_pool_size=100m scope=spfile;

系统已更改。

SQL> shutdown immediate
ORA-01507: 未装载数据库

ORACLE 例程已经关闭。
--当前共享池的容量是大约78m，当大池的容量超过共享池时系统出现了ORA-04031错误
SQL> startup
ORA-04031: unable to allocate 483344 bytes of shared memory ("shared pool","unkn
own object","sga heap(1,0)","jsksncb: 7")
SQL> select status from v$instance;
select status from v$instance
*
第 1 行出现错误:
ORA-01034: ORACLE not available

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-1035876/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19602/viewspace-1035876/