Current SCN in Redo, 8i Standby DB

Does anyone have an idea about how to determine what the high (current) SCN is inside of the current redo log group? I can't seem to find that in any V$ views.

I'd like to develop a stored procedure that can be invoked every 5 minutes, look to see if the current SCN has changed, execute "alter system archive log current" if it has, which will push out a new archive log to my standby database... Thereby keeping the standby a maximum of 5 minutes stale.

TIA,
Pete

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 03 2000 - 12:01:14 CST