Home » RDBMS Server » Server Administration » Archivelog grows too fast
Archivelog grows too fast [message #202502] Fri, 10 November 2006 01:38 Go to next message
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
Re: Archivelog grows too fast [message #202514 is a reply to message #202502] Fri, 10 November 2006 02:54 Go to previous messageGo to next message
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.
Re: Archivelog grows too fast [message #202714 is a reply to message #202502] Sat, 11 November 2006 04:29 Go to previous message
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
Previous Topic: Information about what is latches
Next Topic: TNS issues! strange!
Goto Forum:
  


Current Time: Thu Dec 05 00:35:07 CST 2024