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;