HPE Community
Operating System - HP-UX
1754818 Members
3118 Online
108825 Solutions
New Discussion юеВ

Logical standby performance

 
Srinikalyan
Regular Advisor

тАО02-18-2009 09:50 AM

тАО02-18-2009 09:50 AM

Logical standby performance

Hi,
Will there be any performance impact when using SQL apply logical standby database compared to direct redo apply physical standby database? Let's take we are doing some bulk delete(around 10k) in primary, will there be any more time lag when replicate to LSDB.
Note: Both primary and LSDB are within the same datacenter.

Thanks,
Srini
0 Kudos
Reply
3 REPLIES 3
Avinash20
Honored Contributor

тАО02-18-2009 09:58 AM

тАО02-18-2009 09:58 AM

Re: Logical standby performance

You could post your query in Oracle Forums
"Light travels faster than sound. That's why some people appear bright until you hear them speak."
0 Kudos
Reply
Avinash20
Honored Contributor

тАО02-18-2009 10:02 AM

тАО02-18-2009 10:02 AM

Re: Logical standby performance

you could refer to forum in oracle or oracle admin guide

http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/server.101/b10823/log_apply.htm
"Light travels faster than sound. That's why some people appear bright until you hear them speak."
0 Kudos
Reply
Sani
Frequent Advisor

тАО02-19-2009 04:05 AM

тАО02-19-2009 04:05 AM

Re: Logical standby performance

Yes , There will time lag.
Because LSDB is more slow than PSDB as because of sql apply is done through log miner technology.

LSDB will extract sql from archive log & then it will apply to standby db.

Where as PSDB log apply will be done block by block.

0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.