HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
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.