How to determine the standby apply delay time from within the database.

Hi,

I would like to be able to determine the delay time set on a physical standy from inspection of the database.

The reason for doing this is so that I can create a script which shows that the applied logs are correct with regard to the delay set.

I expected this to be possible from the following column v$archivelog_dest.delay_mins.

However, this is set to 0 on both the primary and standby databases.

I know that the delay set on the standby is 60 mins. I issued the command below on the standby and can see that the logs applied are 60 minutes behind the primary.