OraFAQ Forum: Server Administration » Got internal error Exception caught in pfrrun() while running PLSQL

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Got internal error Exception caught in pfrrun() while running PLSQL [message #347976]

Mon, 15 September 2008 04:16

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

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 14:27:54 CST 2024