Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Oracle Streams - Problems with Apply Process
marksmithy69
post May 12 2010, 09:39 AM
Post #1


Member
**

Group: Members
Posts: 21
Joined: 2-February 09
Member No.: 39,623



Hello everyone. I am having a problem with my apply process. I have 2 databases (10.2.0.4) which are both capturing changes, and propagating to one another. My problem is, one of the databases is not applying the changes that have propagated from the other. The changes are just sitting in the apply queue. If I go to the alert log, I see this error:

A005: warning -- apply server 1, sid 283 waiting on user sid 293 for event (since 601 seconds):

If I try and stop the apply process, I get a timeout error:

begin dbms_apply_adm.stop_apply ('APLY_FROM_CNTRL'); end;

ORA-26672: timeout occurred while stopping STREAMS process APLY_FROM_CNTRL
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 628
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 55
ORA-06512: at line 1

I was able to stop the apply process using the force option, but after I restart the apply process, I see the same errors in the alert log.


If I check v$streams_apply_reader, I see that my apply process is sitting in an IDLE state. Does anyone have any ideas? Thanks a lot.
Go to the top of the page
 
+Quote Post
Brian Carr
post May 12 2010, 12:50 PM
Post #2


Advanced Member
***

Group: Members
Posts: 242
Joined: 14-August 07
Member No.: 11,137



>> A005: warning -- apply server 1, sid 283 waiting on user sid 293 for event (since 601 seconds):
What is user sid 293 doing? http://www.dba-oracle.com/concepts/query_a...036;session.htm


--------------------
Go to the top of the page
 
+Quote Post
burleson
post May 12 2010, 02:16 PM
Post #3


Advanced Member
***

Group: Members
Posts: 11,640
Joined: 26-January 04
Member No.: 13



Hi,

I noticed that you posted this question on multiple forums.

The most common causes of the "warning - apply server waiting on user" error are

- a CPU enqueue
- a missing index causing a full scan operation
- a DML bottleneck on the database.


>> ORA-26672: timeout occurred while stopping STREAMS process

The book "Oracle Streams" has some great troubleshooting information on this issue:

http://www.rampant-books.com/book_0402_streams.htm

Also, see here, how to troubleshoot a slow Streams apply process:

http://www.dba-oracle.com/t_ora_26672_time...ams_process.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
JGarmany
post May 12 2010, 04:45 PM
Post #4


Advanced Member
***

Group: Members
Posts: 359
Joined: 18-March 04
Member No.: 57



What is the blocking user doing. Possible a select for update?
Have you setup a heart beat table? Are updates to the table being applied to the destination?
If the heart beat table is being updated then the apply process is applying.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 1st November 2014 - 04:31 AM