I can. But wanted to know if querying standlone only will tell me how much it is lagging behind. Regards Sandeep On 2/9/06, Chris Stephens <cstephens16@xxxxxxxxx> wrote: > huh? why can't you get the max scn from the primary at the same time > you get the max scn from the standby and then just use the > scn_to_timestamp to get the difference? -- //www.freelists.org/webpage/oracle-l