Home » Server Options » Data Guard » Performance Problem due to standby database
Performance Problem due to standby database [message #170370] Wed, 03 May 2006 08:32 Go to next message
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.
Re: Performance Problem due to standby database [message #172062 is a reply to message #170370] Sat, 13 May 2006 23:25 Go to previous messageGo to next message
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
Re: Performance Problem due to standby database [message #172111 is a reply to message #170370] Sun, 14 May 2006 23:55 Go to previous messageGo to next message
Man Mohan Sharma
Messages: 35
Registered: October 2003
Member
How I enabled the maximum protection mode ?
Re: Performance Problem due to standby database [message #173676 is a reply to message #172111] Tue, 23 May 2006 23:28 Go to previous message
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
Previous Topic: i want to start data garud
Next Topic: Standby Swtich over
Goto Forum:
  


Current Time: Thu Mar 28 09:52:14 CDT 2024