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