cancel
Showing results for 
Search instead for 
Did you mean: 

Logical standby performance

Srinikalyan
Regular Advisor

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
3 REPLIES
Avinash20
Honored Contributor

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."
Avinash20
Honored Contributor

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."
Sani
Frequent Advisor

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.