Running out of memory
I always get an ORA-4031 error (out of memory).
What V$ performance view will I get the info of current
running programs that eat a lot of memory (the most)?
What is the OS & Oracle ?
Life is a journey, not a destination!
Shared Pool Fragementation.
Search Metalink. There are few good documents on this. Also there are some associated bugs.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
There are many reasons why you get 4031 error.
1 Shared Pool Size is small
2 Fragmentation in SP
You can flush the recreateable objects in the SP by issuing
"ALTER SYSTEM FLUSH SHARED_POOL" statement. However, there is a drawback here. The cached sequences are gone. In order to avoid the gaps in the sequences, you have to pin the Sequences after the db startup. Also, you must pin large pkgs after the db startup.
Hi Thanks all,
Sorry to repond late,
OS AIX 4.3.2
I already increased shared_pool from 60Mb to 120Mb. We
have 1Gb memory.
I also flush shared_pool every 12mn. Is bouncing the DB back
But the error still persist.
I'm still trying to download the mentioned patch (220.127.116.11)
This problem occured to me
ENV: oracle 18.104.22.168 on HP-UX 64
condition: loading xml files into temp tables by using DBMS_XMLSAVE
solution: metalink document says:
1. create special functions with system or sys as owner(don't remember)
2. execute these functions for the session which is having this memory problem.
3. These functions increase session memory for the duration of the session.
4. I was told these bugs will be fixed in 8.1.7 version.
Good luck !!
You may reference the Note:146599.1 in metalink.
Oracle Is My all.
Click Here to Expand Forum to Full Width