Hi Friends,
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)?
Thanks
Printable View
Hi Friends,
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)?
Thanks
What is the OS & Oracle ?
Sam
Shared Pool Fragementation.
Search Metalink. There are few good documents on this. Also there are some associated bugs.
HTH
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
DB 8.1.7
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
better?
But the error still persist.
I'm still trying to download the mentioned patch (8.1.7.4)
This problem occured to me
ENV: oracle 8.1.6.2 on HP-UX 64
condition: loading xml files into temp tables by using DBMS_XMLSAVE
package.
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.