Listing 1 Script to monitor managed recovery

-------------------------------------------------------------------------
--  SCRIPT:        dg_mngd_standby.sql
--
--  Description:   DataGuard Script to monitor Managed Standby processes.
--
--  Author:        Aaron Diehl
--
--  Date:          June 2006
--
--  Modifications:    
--
-------------------------------------------------------------------------
SELECT    process, 
    client_process client_proc, 
    sequence#, 
    status,
    block#,
    blocks
FROM    v$managed_standby
ORDER BY 1,3;