Home » Server Options » Streams & AQ » Oracle Streams - When did the last apply process happen?
Oracle Streams - When did the last apply process happen? [message #75751] Thu, 04 November 2004 06:31 Go to next message
Ravi Kanth Perepu
Messages: 8
Registered: August 2004
Junior Member
Hi All,

 Is there a way to check whey was the last apply process applied on the target in streams configuration?

Regards

Ravi
Re: Oracle Streams - When did the last apply process happen? [message #75755 is a reply to message #75751] Thu, 11 November 2004 04:53 Go to previous message
Ravi Kanth Perepu
Messages: 8
Registered: August 2004
Junior Member
HI All,
I found that myself

--
select CAPTURE_TIME
from V$STREAMS_CAPTURE
where sid=(select max(sid) from V$STREAMS_CAPTURE)

Regards
Ravi
Previous Topic: oracle streams?
Next Topic: Problem due to deletion records from OBJ$ table
Goto Forum:
  


Current Time: Tue Sep 16 15:24:04 CDT 2014

Total time taken to generate the page: 0.08961 seconds