OraFAQ Forum: Backup & Recovery » ora 4030 while using logminer

Home » RDBMS Server » Backup & Recovery » ora 4030 while using logminer

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

ora 4030 while using logminer [message #191428]

Wed, 06 September 2006 06:04

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

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 17:07:14 CDT 2025