Home » RDBMS Server » Enterprise Manager » generating too much archive logs
generating too much archive logs [message #233341] Wed, 25 April 2007 14:33 Go to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Hi,
DB : 817
OS : Sun Solaris

One of my db is on 817 and somehow archive is generating very fast, Normally it's generating approx couple of dozens in a day. But at present it's generating every after 2 to 3 minutes.

There is no background job is running, no application changes from last 1 month... What could be the reason for the same?


Regards,
Harshad

[Updated on: Wed, 25 April 2007 14:49]

Report message to a moderator

Re: generating too much archive logs [message #235671 is a reply to message #233341] Mon, 07 May 2007 11:32 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Increased DB activity? Check who are logged-in and what they are doing.
Re: generating too much archive logs [message #235694 is a reply to message #235671] Mon, 07 May 2007 12:41 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
I have checked at that time, no too much activity and eventually after few minutes it's started behaving normal. It seems there is issue with roll back. Anyways thanks for your reply after long time.
Re: generating too much archive logs [message #235697 is a reply to message #235694] Mon, 07 May 2007 12:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle does not generate redo or undo for nothing, only if you ask it to.
Check again your activity, you surely miss something.

Use StatsPack during these hours.
User LogMiner to check what has been done.

Regards
Michel
Re: generating too much archive logs [message #235710 is a reply to message #235697] Mon, 07 May 2007 14:10 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Michel,

I have checked everything during that time, Only I am not able to check is statspack reports. I have check all the possibilities, I have checked status of tablespaces also, I have to monitor the session who is generating more redos. Weired thing is that after few minutes it's got disappeared.


Regards,
Harshad

[Updated on: Mon, 07 May 2007 14:10]

Report message to a moderator

Re: generating too much archive logs [message #235711 is a reply to message #233341] Mon, 07 May 2007 14:15 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
IMO, the best tool to solve this mystery is LogMiner to actually see who is changing what that generates all the redo activity.
Re: generating too much archive logs [message #235714 is a reply to message #235711] Mon, 07 May 2007 14:32 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
FYI... There are certain parameters which are responsible for the same. fast_start_parallel_rollback .. whcih causes more redos.
Re: generating too much archive logs [message #235716 is a reply to message #235714] Mon, 07 May 2007 14:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you explain?

Regards
Michel
Re: generating too much archive logs [message #235718 is a reply to message #235716] Mon, 07 May 2007 14:51 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Michel,

You can check this Doc in metalink 2186174.8, It's fixed in 9203.


Regards,
Harshad
Re: generating too much archive logs [message #235722 is a reply to message #235718] Mon, 07 May 2007 15:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a bug not a normal processing so your post is wrong:
Quote:
There are certain parameters which are responsible for the same. fast_start_parallel_rollback .. whcih causes more redos

NO. fast_start_parallel_rollback does not generate much more redo... unless there is a bug.

You should post "there is a bug in certain versions that leads to more redo generation when fast_start_parallel_rollback is set to true. Have a look at Metalink note 2186174.8".
Your current post is misleading.

Regards
Michel
icon14.gif  Re: generating too much archive logs [message #235726 is a reply to message #235722] Mon, 07 May 2007 15:10 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
As you have clarify the things, thanks for that. Razz
Re: generating too much archive logs [message #235731 is a reply to message #235726] Mon, 07 May 2007 15:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the Metalink note.

Regards
Michel
Re: generating too much archive logs [message #237602 is a reply to message #235731] Tue, 15 May 2007 02:06 Go to previous message
markog
Messages: 5
Registered: May 2007
Location: Poland
Junior Member
Switching tablespaces to backup mode generates more logs.
Previous Topic: Your username and/or password are invalid
Next Topic: EM page not loading
Goto Forum:
  


Current Time: Sat Dec 10 18:41:26 CST 2016

Total time taken to generate the page: 0.25855 seconds