Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Shared_pool_size and stream_pool_size

480011Jun 23 2006 — edited Jun 23 2006
I got a problem to increase the size of stream_pool_size in Oracle 10g R2.

This is the information when starting the instance.
Total System Global Area 1073741824 bytes
Fixed Size 1223540 bytes
Variable Size 1044382860 bytes
Database Buffers 20971520 bytes
Redo Buffers 7163904 bytes


SQL> show parameter sga_max_size ;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 1G

SQL> show parameter sga_target;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_target big integer 900M

SQL> show parameter pool;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_keep string
buffer_pool_recycle string
global_context_pool_size string
java_pool_size big integer 0
large_pool_size big integer 0
olap_page_pool_size big integer 0
shared_pool_reserved_size big integer 30M
shared_pool_size big integer 600M
streams_pool_size big integer 252M


I want to increase streams_pool_size by this command but got error.

alter system set STREAMS_POOL_SIZE =300M sid = 'orcl1';
alter system set STREAMS_POOL_SIZE =300M sid = 'orcl1'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool

Correct me if I am wrong? Is the maximum number I could bring streams_pool_size is the value of shared_pool_size? How could I increase the stream_pool_size?
Your help is very much appreciated.

Amy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2006
Added on Jun 23 2006
1 comment
754 views