Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006

    Unanswered: Shared_pool_size

    Hi Experts,

    I had already discussed on issues related to shared_pool_size.

    These are the values for the allocated memory in my oracle 9i database

    large_pool_size 0
    db_keep_cache_size 0
    db_2k_cache_size 0
    db_recycle_cache_size 0
    db_4k_cache_size 0
    db_16k_cache_size 0
    db_32k_cache_size 0
    db_8k_cache_size 0
    log_buffer 1
    java_pool_size 32
    shared_pool_size 160
    db_cache_size 464
    sga_max_size 705.964775

    When I tried to increase the shared_pool_size to 200M, the foll.error was thrown.

    alter system set shared_pool_size=200M;

    ORA-02097: parameter cannot be modified because specified value is invalid
    ORA-04033: Insufficient memory to grow pool

    Pl. advice me on this as it is not allowing me to increase even 1 MB size.


  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    Try increasing the SGA_Max_Size first.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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