Home » RDBMS Server » Server Administration » Got internal error Exception caught in pfrrun() while running PLSQL (Oracle Version is 10.2.0.1.0 and OS is RHEL AS 4)
Got internal error Exception caught in pfrrun() while running PLSQL [message #347976] Mon, 15 September 2008 04:16 Go to next message
rtjk
Messages: 33
Registered: February 2005
Member
Hi All,

Version details are as follows

Oracle Version is 10.2.0.1.0 and OS is RHEL AS 4

In our oracle server trace files are getting generated frequently of size 4 to 5GB whenever users are running some PL/SQL.

All Trace files are having the following errors.

***Got internal error Exception caught in pfrrun() while running PLSQL***
***Got ORA-4030 while running PLSQL***

Do we need to apply any patch.Any help is appreciated much.

Regards,
Jayakumar
Re: Got internal error Exception caught in pfrrun() while running PLSQL [message #347981 is a reply to message #347976] Mon, 15 September 2008 04:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Got internal error Exception caught in pfrrun() while running PLSQL

This is NOT an Oracle error but an application one.

ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted
 *Action:

Check ulimit and if possible increase memory limits.

Regards
Michel
Re: Got internal error Exception caught in pfrrun() while running PLSQL [message #347992 is a reply to message #347981] Mon, 15 September 2008 05:16 Go to previous messageGo to next message
rtjk
Messages: 33
Registered: February 2005
Member
Hi Michael,

I have checked ulimits in OS level for the Oracle software owner.Got the o/p as following.

time(cpu-seconds) unlimited
file(blocks) unlimited
coredump(blocks) 0
data(kbytes) unlimited
stack(kbytes) 10240
lockedmem(kbytes) 32
memory(kbytes) unlimited
nofiles(descriptors) 1024
processes 137216


Regards,
Jayakumar
Re: Got internal error Exception caught in pfrrun() while running PLSQL [message #347995 is a reply to message #347992] Mon, 15 September 2008 05:43 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check hardware limits (ulimit -Ha).
If you can't enlarge them, you only have 2 solutions:
- Use less memory (that is search what is the offending procedureand rewrite it)
- Upgrade hardware

Regards
Michel
Previous Topic: ORA-00600: internal error code, arguments: [qernsRowP], [1], [], [], [], [], [], []
Next Topic: Get Default Datafile directory
Goto Forum:
  


Current Time: Thu Dec 08 10:29:45 CST 2016

Total time taken to generate the page: 0.09671 seconds