In 9i I change db_cache_size return error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: In 9i I change db_cache_size return error

  1. #1
    Join Date
    May 2002
    Posts
    34
    Hi: In Oracle 9i my machine has enough memory(vmstat 5)
    and I execute "alter system set db_cache_size=128M scope=both;" the error is "ERROR at line 1:
    ORA-02097: parameter cannot be modified because specified value is invalid
    ORA-00384: Insufficient memory to grow cache"
    the parameter sga_max_size is very large can not be exceed? what is the error? Thanks !!!

  2. #2
    Join Date
    Feb 2001
    Posts
    290
    Did you see the parameter db_block_buffers in the init.ora ???

    Madhu Reddy
    xdollor@yahoo.com

  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Take care that u are not trying to exceed the sga_max_size. Verify u'r sga_max_size.

    Execute the same statement with lesser value for db_cache_size that is below sga_max_size. That should work.

    Cheers.





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