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

Thread: SGA_TARGET causes ora-04030, 04031

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    Question SGA_TARGET causes ora-04030, 04031

    Hi, I have a database(10.2.0.4) 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
    Location
    Charlotte, NC
    Posts
    865
    (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.

    https://support.oracle.com/CSP/ui/fl...ource=KB%29%29

    Thanks,
    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