 |
|
Oracle
Tips by Burleson |
Tracking down ORA-04030 errors
If a process size keeps growing, then it may eventually fail with an
ORA-4030 "out of process memory when trying to allocate %s bytes"
error if the operating system is exhausted of memory, or the memory
size hits some operating system defined limit (such as maxdsiz on
HP-UX).
To start diagnosing a problem with the process size, such as a
suspected memory leak, a heapdump of the offending process is
required:
$ sqlplus /nolog
SQL> connect sys as sysdba
Password: xxxxxxxxx
Connected.
SQL> oradebug setospid <pid>
SQL> oradebug unlimit
SQL> oradebug dump heapdump 5 <--this dumps PGA and UGA heaps
This is a book excerpt from:
Using the
Oracle oradebug Utility
Debugging Oracle Applications
Mike Ault
ISBN: 0-9740716-7-6
http://www.rampant-books.com/ebook_oradebug.htm
|
