Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Relpication very slow

1006937Oct 14 2013 — edited Oct 14 2013

hi,

11.2.0.2

I have Logical Data Guard which is very slow

select * from v$logstdby

383-132011COORDINATOR16116ORA-16116: no work available511796345570
6325032557ANALYZER16116ORA-16116: no work available511796328343
6779132559APPLIER16121ORA-16121: applying transaction with commit SCN 0x0077.297035e2511796327906
6275232561APPLIER16116ORA-16116: no work available
467332563APPLIER16116ORA-16116: no work available
4725432565APPLIER16116ORA-16116: no work available
251532567APPLIER16116ORA-16116: no work available
3117632569APPLIER16116ORA-16116: no work available
3169732571APPLIER16116ORA-16116: no work available
475832573APPLIER16116ORA-16116: no work available
399102432015READER16127ORA-16127: stalled waiting for additional transactions to be applied511796345530
1123102532017BUILDER16127ORA-16127: stalled waiting for additional transactions to be applied511796345530
605102632019PREPARER16127ORA-16127: stalled waiting for additional transactions to be applied511796328342
2865102732021PREPARER16127ORA-16127: stalled waiting for additional transactions to be applied511796328338
631102832023PREPARER16127ORA-16127: stalled waiting for additional transactions to be applied511796328338
5083102932025PREPARER16127ORA-16127: stalled waiting for additional transactions to be applied511796328343

applying transaction with commit SCN 0x0077.297035e2 is very very very slow

What could be the problem ?

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2013
Added on Oct 14 2013
#data-guard, #performance-availability
17 comments
2,372 views