DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: setting streams_pool_size

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    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;

    BANNER
    ----------------------------------------------------------------
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
    PL/SQL Release 10.2.0.1.0 - Production
    CORE 10.2.0.1.0 Production
    TNS for Solaris: Version 10.2.0.1.0 - Production
    NLSRTL Version 10.2.0.1.0 - 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
    Location
    England
    Posts
    7,334
    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