High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

sql apply is too slow on the logical standby

Hi ,

I have a DG consist of one logical standby. Now there is about 800 ArchiveLog are not applied on the database, I notice that the SQL_APPLY took too long time with the archiveLog to be applied.

Note: ArchiveLog Avarage Size : 440M

how can I make faster, specially that no one using it now, but we need to sync with the primary DB as soon as possible.

please Note that the total DB are stored on SSD Disk, 2 Physical CPU each one has 8 Cores, SGA_MAX_SIZE = 700G, SGA_TARGET= 700G

select count(*), type from V$LOGSTDBY_PROCESS  group by type;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center