Home » RDBMS Server » Server Administration » ora 4030 while using logminer
ora 4030 while using logminer [message #191387] Wed, 06 September 2006 01:53 Go to next message
lokeshonline
Messages: 29
Registered: April 2006
Junior Member
When I try to query from v$logmnr_contents it gives error ora 4030 out of memory. I am using oracle 9.2.0.1 on aix 5. Any help?? This error occurs even if I analyze only one archive file.
Re: ora 4030 while using logminer [message #191390 is a reply to message #191387] Wed, 06 September 2006 01:58 Go to previous messageGo to next message
wwllzpz
Messages: 11
Registered: December 2005
Location: shanghai china
Junior Member

ORA-04030 out of process memory when trying to allocate string bytes (string,string)

Cause: Operating system process private memory has been exhausted.

Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.

Re: ora 4030 while using logminer [message #191427 is a reply to message #191390] Wed, 06 September 2006 06:03 Go to previous messageGo to next message
lokeshonline
Messages: 29
Registered: April 2006
Junior Member
I read the same from oracle error messages list but I want to know how can process memory increase. Second thing it is a dbms_logmnr inbuilt package in Oracle. It stores all the queries recorded in archive files in v$logmnr_contents.
Re: ora 4030 while using logminer [message #191526 is a reply to message #191427] Wed, 06 September 2006 22:27 Go to previous messageGo to next message
wwllzpz
Messages: 11
Registered: December 2005
Location: shanghai china
Junior Member

increase your physical memory .or maybe you may decrease SGA.
Re: ora 4030 while using logminer [message #191591 is a reply to message #191526] Thu, 07 September 2006 03:36 Go to previous messageGo to next message
lokeshonline
Messages: 29
Registered: April 2006
Junior Member
from topas I can see more than 2.5GB memory is free. Total memory is 8GB. 3GB is SGA. 1GB is PGA.
Re: ora 4030 while using logminer [message #192009 is a reply to message #191591] Sat, 09 September 2006 14:25 Go to previous message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Are You running on 64 bit?
Or have You configured VLM?
The issue is the the O/S are not able to give the Oracle process any more memory, so if You think there are free memory, this is probably a configuration issue.

Br
Kim Anthonisen
Previous Topic: ORA0410: invalid ROWID
Next Topic: Checkpoints and Commits
Goto Forum:
  


Current Time: Sat Dec 10 18:30:37 CST 2016

Total time taken to generate the page: 0.08332 seconds