OraFAQ Forum: Server Administration » excessive archive log are generating by oracle

Home » RDBMS Server » Server Administration » excessive archive log are generating by oracle (oracle 9.2.0.7 )

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

excessive archive log are generating by oracle [message #399940]

Fri, 24 April 2009 10:55

kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville

Member

Hello Experts,

i am getting new problem with one of the database running on 9.2.0.7 version. suddenly it is generating too many archive logs.
i have checked in the alert log , tablespace status, datafile status and checked for backup too. i could not able to get any useful hint from the database.

i have checked incoming transaction that is also looks normal.

i was not able to find problem. can any one help me to find the problem.

-- Jyothy ..

Report message to a moderator

Re: excessive archive log are generating by oracle [message #399955 is a reply to message #399940]

Fri, 24 April 2009 12:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

somebody is doing lots of DML

Report message to a moderator

Re: excessive archive log are generating by oracle [message #399963 is a reply to message #399955]

Fri, 24 April 2009 12:40

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Also; If you want avoid; check ARCHIVE_LAG_TARGET

Report message to a moderator

Re: excessive archive log are generating by oracle [message #399968 is a reply to message #399963]

Fri, 24 April 2009 12:56

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

Senior Member
Account Moderator

How ARCHIVE_LAG_TARGET will avoid redo generation?

Regards
Michel

Report message to a moderator

Re: excessive archive log are generating by oracle [message #399974 is a reply to message #399940]

Fri, 24 April 2009 13:36

kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville

Member

Thanks Every one for suggestion.

i have checked that too. incoming transaction are as usual.
no import operations as well as Maintainace tasks are running.

how do i check lots of DML operation?
is there any way to find?

Report message to a moderator

Re: excessive archive log are generating by oracle [message #399984 is a reply to message #399940]

Fri, 24 April 2009 15:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>is there any way to find?
query V$SESS_IO is one way

Report message to a moderator

Re: excessive archive log are generating by oracle [message #399987 is a reply to message #399984]

Fri, 24 April 2009 16:31

varunvir
Messages: 389
Registered: November 2007

Senior Member

One possible solution is to increase the size of redo logs.
Regards,
Varun Punj,

Report message to a moderator

Re: excessive archive log are generating by oracle [message #400020 is a reply to message #399987]

Sat, 25 April 2009 00:58

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

Senior Member
Account Moderator

Of course this will not reduce the size of redo logs generated just the number of archived logs.
And I think OP problem is the size not the number in itself.

Regards
Michel

Report message to a moderator

Re: excessive archive log are generating by oracle [message #401095 is a reply to message #400020]

Fri, 01 May 2009 09:29

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

If you run StatsPack / AWR then that will tell you what's running at the moment.

You could look in V$Session to see what sessions are currently active, and then look at v$sql to see what the SQL being run is.

Report message to a moderator

Re: excessive archive log are generating by oracle [message #401134 is a reply to message #399940]

Fri, 01 May 2009 14:52

satishnawle
Messages: 3
Registered: May 2009

Junior Member

Dear

if set archive_lag_target parameter then change value of that parameter else there same problem with application code

Satish Nawle
9222130789

Report message to a moderator

Previous Topic:	Finding number of transactions
Next Topic:	v$system_event vs. v_$system_event

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 13:31:15 CST 2024