-
Running out of memory
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
Thanx
Sam
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.
HTH
Sanjay G.
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
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 !!
Brahmaiah Koniki
-
You may reference the Note:146599.1 in metalink.
Oracle Is My all.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|