OraFAQ Forum: Enterprise Manager » generating too much archive logs

Home » RDBMS Server » Enterprise Manager » generating too much archive logs

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

generating too much archive logs [message #233341]

Wed, 25 April 2007 14:33

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

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Increased DB activity? Check who are logged-in and what they are doing.

Report message to a moderator

Re: generating too much archive logs [message #235694 is a reply to message #235671]

Mon, 07 May 2007 12:41

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.

Report message to a moderator

Re: generating too much archive logs [message #235697 is a reply to message #235694]

Mon, 07 May 2007 12:55

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: generating too much archive logs [message #235710 is a reply to message #235697]

Mon, 07 May 2007 14:10

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: generating too much archive logs [message #235714 is a reply to message #235711]

Mon, 07 May 2007 14:32

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.

Report message to a moderator

Re: generating too much archive logs [message #235716 is a reply to message #235714]

Mon, 07 May 2007 14:46

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Can you explain?

Regards
Michel

Report message to a moderator

Re: generating too much archive logs [message #235718 is a reply to message #235716]

Mon, 07 May 2007 14:51

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

Report message to a moderator

Re: generating too much archive logs [message #235722 is a reply to message #235718]

Mon, 07 May 2007 15:04

Michel Cadot
Messages: 68645
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

Report message to a moderator