SGA_TARGET causes ora-04030, 04031 Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SGA_TARGET causes ora-04030, 04031

  1. #1
    Join Date
    Jul 2001

    Question SGA_TARGET causes ora-04030, 04031

    Hi, I have a database( running on a Windows 2003 Server, 32bit. The server has 8G of Ram, When I set the SGA_target=1.5G and leave out the sga cache parameters, after a few days I get many ora-04031 and ora-04030 errors. However, if I leave out the SGA_TARGET parameter and hard code the sga cache parameters(total 1.5G) , I never get these errors. Why ?

  2. #2
    Join Date
    Mar 2006
    Charlotte, NC
    (from Metalink note)

    * SGA components too small for workload
    * Auto-tuning issues
    * Fragmentation due to application design
    * Bug/leaks in memory allocations

    Please go through the below metalink URL and find the note relavent to your issue.

    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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