OraFAQ Forum: Streams & AQ » Oracle Streams - When did the last apply process happen?

Home » Server Options » Streams & AQ » Oracle Streams - When did the last apply process happen?

Thu, 04 November 2004 06:31

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

Thu, 11 November 2004 04:53

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 Apr 16 02:57:29 CDT 2024