Home » RDBMS Server » Server Administration » excessive archive log are generating by oracle (oracle 9.2.0.7 )
excessive archive log are generating by oracle [message #399940] Fri, 24 April 2009 10:55 Go to next message
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 ..
Re: excessive archive log are generating by oracle [message #399955 is a reply to message #399940] Fri, 24 April 2009 12:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
somebody is doing lots of DML
Re: excessive archive log are generating by oracle [message #399963 is a reply to message #399955] Fri, 24 April 2009 12:40 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Also; If you want avoid; check ARCHIVE_LAG_TARGET
Re: excessive archive log are generating by oracle [message #399968 is a reply to message #399963] Fri, 24 April 2009 12:56 Go to previous messageGo to next message
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
Re: excessive archive log are generating by oracle [message #399974 is a reply to message #399940] Fri, 24 April 2009 13:36 Go to previous messageGo to next message
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?
Re: excessive archive log are generating by oracle [message #399984 is a reply to message #399940] Fri, 24 April 2009 15:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>is there any way to find?
query V$SESS_IO is one way
Re: excessive archive log are generating by oracle [message #399987 is a reply to message #399984] Fri, 24 April 2009 16:31 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
One possible solution is to increase the size of redo logs.
Regards,
Varun Punj,
Re: excessive archive log are generating by oracle [message #400020 is a reply to message #399987] Sat, 25 April 2009 00:58 Go to previous messageGo to next message
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
Re: excessive archive log are generating by oracle [message #401095 is a reply to message #400020] Fri, 01 May 2009 09:29 Go to previous messageGo to next message
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.
Re: excessive archive log are generating by oracle [message #401134 is a reply to message #399940] Fri, 01 May 2009 14:52 Go to previous message
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
Previous Topic: Finding number of transactions
Next Topic: v$system_event vs. v_$system_event
Goto Forum:
  


Current Time: Mon Dec 02 08:57:36 CST 2024