OraFAQ Forum: Data Guard » Performance Problem due to standby database

Home » Server Options » Data Guard » Performance Problem due to standby database

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

Performance Problem due to standby database [message #170370]

Wed, 03 May 2006 08:32

Man Mohan Sharma
Messages: 35
Registered: October 2003

Member

I have made physical standby database.
but due to this my primary database getting slow. so what I do to optimize performance.

Report message to a moderator

Re: Performance Problem due to standby database [message #172062 is a reply to message #170370]

Sat, 13 May 2006 23:25

jagjeet.malhi
Messages: 4
Registered: March 2006
Location: India

Junior Member

Hi Manmohan,

Have you enabled the maximum protection mode ?

IF not then how did you realize performance degradtion.

Regards,
Js

Report message to a moderator

Re: Performance Problem due to standby database [message #172111 is a reply to message #170370]

Sun, 14 May 2006 23:55

Man Mohan Sharma
Messages: 35
Registered: October 2003

Member

How I enabled the maximum protection mode ?

Report message to a moderator

Re: Performance Problem due to standby database [message #173676 is a reply to message #172111]

Tue, 23 May 2006 23:28

jagjeet.malhi
Messages: 4
Registered: March 2006
Location: India

Junior Member

Sorry for delay reply.

Bydefault mode is "Maximum Performance"

If you have not done anything then you probably using this mode.

For checking purpose you can issue

Select protection_mode from v$database on standby database.

It should show you to "maximum performance"

and second thing you are not using LGWR for pushing archive files
to STANDBY Server.

you can see this by log_archive_Dest_n parameter which you modified
for your standby site. If it does not contain "LGWR" word then
it is using archiver for pushing the file to standby.

and for confirmation you can check through

Select creator,name from v$archived_log on production box.

it should show you "ARCH"

and if you got any diff. result for both queries then please
post it else standby is not the resone of slow performance of production.

Regards,
Jagjeet Singh

Report message to a moderator

Previous Topic:	i want to start data garud
Next Topic:	Standby Swtich over

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 27 01:45:39 CST 2021