Home » RDBMS Server » Backup & Recovery » ora 4030 while using logminer
ora 4030 while using logminer [message #191428] Wed, 06 September 2006 06:04 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 #191828 is a reply to message #191428] Fri, 08 September 2006 05:07 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Add more memory?

You give no details as to how much memory You have on the machine, and how much are used....

Br
Kim
Re: ora 4030 while using logminer [message #191947 is a reply to message #191828] Fri, 08 September 2006 21:59 Go to previous messageGo to next message
lokeshonline
Messages: 29
Registered: April 2006
Junior Member
Total memory is 8GB. 3GB is SGA. 1GB is PGA. from topas I can see more than 2.5GB memory is free.
Re: ora 4030 while using logminer [message #191965 is a reply to message #191947] Sat, 09 September 2006 06:50 Go to previous message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Are You on 64 bit, or have You configured VLM etc. ?
- If not, You probably have to Wink
Previous Topic: backup up of raw devies
Next Topic: Rename a database
Goto Forum:
  


Current Time: Thu Dec 08 12:13:24 CST 2016

Total time taken to generate the page: 0.11438 seconds