Home » Server Options » Streams & AQ » Streams capture: waiting for archive log (Oracle 10g 10.2.0.3.0 on linux 64 bit)
Streams capture: waiting for archive log [message #348914] Thu, 18 September 2008 05:12 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
I have set up one way replication from Production to backup server. It is working fine but in Oracle Enterprise Manager there is Wait in "ACTIVE SESSION" graph.

In message window it is showing following

Waits by Wait Class Database Time Spent Waiting (%) Metrics "Database Time Spent Waiting (%)" is at 30.80856 for event class "Other"

and in finding following is the message

Wait event "Streams capture: waiting for archive log" in wait class "Other" was consuming significant database time.

But top command in linux is not showing any visible use of cpu and Memory
I am using local capture, why it is waiting for archivelog?.

I did manual log switch and new archive log created, but no change

And this finding is there and not going. So what should we do

[Updated on: Thu, 18 September 2008 06:10]

Report message to a moderator

Re: Streams capture: waiting for archive log [message #349052 is a reply to message #348914] Thu, 18 September 2008 13:10 Go to previous messageGo to next message
macdba
Messages: 27
Registered: May 2005
Location: US
Junior Member
This is an idle wait so it is not a performance problem. It's just the capture process saying it has nothing to do because it is waiting for another archive log to become available. It isn't wasting any system resources or affecting performance. There is no action necessary for this wait.

regards
--Mak
Re: Streams capture: waiting for archive log [message #349199 is a reply to message #349052] Fri, 19 September 2008 04:51 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
But in EM, it is constantly showing the finding after every hour and in Active session Graph Wait displayed.

How do we get rid of finding
Re: Streams capture: waiting for archive log [message #413388 is a reply to message #349052] Wed, 15 July 2009 08:25 Go to previous message
upanwar
Messages: 24
Registered: July 2007
Location: mumbai
Junior Member

Hi Mak,

I have one question for you .. Can you please help me out.

We have bi directional replication setup between two databases and working fine on cin192 ux server.

we have our server from cin192ux to cin191ux...when we checked our process ..capture process still waiting for dictionary redo on cin192ux server. We have move our server via cold backup...

how i can resolve this issue?

Do we need to reconfigure the streams setup...or any other way so we can point new redo /archive log file to capture process.

Please help...

thanks in advance...!!!!!!!
Previous Topic: Granting capture rules script does not finish
Next Topic: Calling procedure with a different user (merged)
Goto Forum:
  


Current Time: Thu Mar 28 17:44:37 CDT 2024