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
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!
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
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
Messages: 69
Registered: July 2006
Location: London
Please see Metalink Note:167492.1 - SQL: How to Find Sessions Generating Lots of Redo.
Previous Topic: Information about what is latches
Next Topic: TNS issues! strange!
Goto Forum:

Current Time: Fri Aug 18 21:01:52 CDT 2017

Total time taken to generate the page: 0.23132 seconds