Home » RDBMS Server » Server Administration » archive log file get increased very high (oracle 9iR2 - RAC - sunOS 5.9)
icon9.gif  archive log file get increased very high [message #306879] Mon, 17 March 2008 02:47 Go to next message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
Hi all,

I am facing a problem that the archive log files are getting generated very high frequently every 5min 1GB. this is ofcourse abnormal on my DB.
I feel something happened ...

Any one can help me?

thanks
Re: archive log file get increased very high [message #306887 is a reply to message #306879] Mon, 17 March 2008 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Take on log and use Log Miner on it.
You can also query v$sesstat for "redo size" statistic to know which session(s) is/are generating redos.

Regards
Michel
Re: archive log file get increased very high [message #306934 is a reply to message #306879] Mon, 17 March 2008 05:44 Go to previous message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
thanks a lot.
Previous Topic: undo tablespace
Next Topic: NO import !
Goto Forum:
  


Current Time: Sat Dec 03 15:56:38 CST 2016

Total time taken to generate the page: 0.04170 seconds