OraFAQ Forum: Performance Tuning » redo logs generating after every 3 min

Home » RDBMS Server » Performance Tuning » redo logs generating after every 3 min (oracle 10.0.2.4/Win 2k3)

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

redo logs generating after every 3 min [message #471402]

Fri, 13 August 2010 21:24

hussain_dilshad
Messages: 11
Registered: August 2009
Location: agra

Junior Member

Hi,
This morning when I checked my archive logs, I suprised that the redo files are generating after every 3 min and each of file size is 50M, which is the actual size of both log members. I m using RAC database with DR server.Usally the total redo logs quantity for one day is 4 to 5. but since 10 pm of yesterday to 7 am today, the quantity of log files are 109, each of 50 M .How is it possible!!!!!!!!!!.
I ve checked alert logs of both node of my RAC.No Ora error found.
pls help

Report message to a moderator

Re: redo logs generating after every 3 min [message #471403 is a reply to message #471402]

Fri, 13 August 2010 21:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How is it possible!!!!!!!!!!.
DML is happening.
DBMS_LOGMNR can reveal what has happened.
You might get clues by querying V$SQL for INSERT, UPDATE, or DELETE

Report message to a moderator

Re: redo logs generating after every 3 min [message #471410 is a reply to message #471403]

Sat, 14 August 2010 00:51

hussain_dilshad
Messages: 11
Registered: August 2009
Location: agra

Junior Member

Thanks,
I traced the problem

Report message to a moderator

Previous Topic:	Low performing query
Next Topic:	TPC-E benchmarking

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 15:00:54 CST 2024