DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009

    setting streams_pool_size

    I am trying to set streams_pool_size and I am getting an oracle error. Can somebody tell me what I need to do in order to fix this.

    SQL> select * from v$version;

    Oracle Database 10g Enterprise Edition Release - 64bi
    PL/SQL Release - Production
    CORE Production
    TNS for Solaris: Version - Production
    NLSRTL Version - Production

    SQL> show sga

    Total System Global Area 310378496 bytes
    Fixed Size 1978272 bytes
    Variable Size 197136480 bytes
    Database Buffers 104857600 bytes
    Redo Buffers 6406144 bytes
    SQL> alter system set streams_pool_size = 50 m;
    alter system set streams_pool_size = 50 m
    ERROR at line 1:
    ORA-02097: parameter cannot be modified because specified value is invalid
    ORA-04033: Insufficient memory to grow pool

  2. #2
    Join Date
    Sep 2002
    what part of the error is confusing you? you ont have enough free memory in the sga to grow it

    increase your sga size

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.