Tip of the Week
Tip for Week of October 31, 2005

Check Log Number Status

This tip comes from Ittichai Chammavanijakul, Lead DBA, at Motorola, in Arlington Heights, IL.

SELECT 'APPLIED' "STATUS", max(L.SEQUENCE#) "LOG#"
FROM DBA_LOGSTDBY_LOG L, DBA_LOGSTDBY_PROGRESS P
where L.NEXT_CHANGE# < P.READ_SCN
union
SELECT 'APPLYING', max(L.SEQUENCE#)
FROM DBA_LOGSTDBY_LOG L, DBA_LOGSTDBY_PROGRESS P
where L.FIRST_CHANGE# < P.APPLIED_SCN
union
SELECT 'RECEIVED', max(SEQUENCE#)
FROM DBA_LOGSTDBY_LOG;


STATUS   LOG#
-------- ----------
APPLIED  13649
APPLYING 13651
RECEIVED 13728