OraFAQ Forum: Server Administration » Archivelog grows too fast

Home » RDBMS Server » Server Administration » Archivelog grows too fast

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

Archivelog grows too fast [message #202502]

Fri, 10 November 2006 01:38

davistai
Messages: 2
Registered: October 2006

Junior Member

I found our archivelog grow very fast, two 100MB archive files in 1 minutes. It makes the filesystem full in a short time.
Could anyone kindly help how to find out and fix the problem?? Thank you very much!
Embarassed

Report message to a moderator

Re: Archivelog grows too fast [message #202514 is a reply to message #202502]

Fri, 10 November 2006 02:54

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Run Statspack. That should show you what's going on in the Db during that period.

Report message to a moderator

Re: Archivelog grows too fast [message #202714 is a reply to message #202502]

Sat, 11 November 2006 04:29

KenJ
Messages: 69
Registered: July 2006
Location: London

Member

Hi,
Please see Metalink Note:167492.1 - SQL: How to Find Sessions Generating Lots of Redo.
HTH,
Ken

Report message to a moderator

Previous Topic:	Information about what is latches
Next Topic:	TNS issues! strange!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:33:06 CDT 2024