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.

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: backup up of raw devies
Next Topic: Rename a database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 08:16:24 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.