OraFAQ Forum: Server Administration » archive log file get increased very high

Home » RDBMS Server » Server Administration » archive log file get increased very high (oracle 9iR2 - RAC - sunOS 5.9)

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

archive log file get increased very high [message #306879]

Mon, 17 March 2008 02:47

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

Report message to a moderator

Re: archive log file get increased very high [message #306887 is a reply to message #306879]

Mon, 17 March 2008 02:54

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: archive log file get increased very high [message #306934 is a reply to message #306879]

Mon, 17 March 2008 05:44

ORA-MAN
Messages: 24
Registered: January 2008
Location: ===

Junior Member

thanks a lot.

Report message to a moderator

Previous Topic:	undo tablespace
Next Topic:	NO import !

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 03:59:40 CST 2024