Find the delay of standby from primary

Here is a quick way to find the current timestamp from the current SCN.

http://www.chandu208.blogspot.com/2012/03/finding-current-scn-of-database.html

On primary:

SQL> select to_char(CURRENT_SCN) from v$database;

TO_CHAR(CURRENT_SCN)

————————————

12345678909

SQL> select scn_to_timestamp(48133107062) from dual;

SCN_TO_TIMESTAMP(12345678909)

—————————————————

19-JUN-11 08.40.27.000000000 AM

SQL>

And do the same on standby database, then find the difference in time.

If you set the delay parameter then find it in the parameter file

Thanks !!