archive_dest_status shows huge elapsed time
Hi ,
I am having 2 node rac 11.2.0.2 .
The below query is completing in 2 to 4 seconds on node 1 , while the same query shows up in awr reports with 0 execution and approx 144 s elaspsed time .
SELECT UNIQUE db_unique_name FROM gv$archive_dest_status WHERE gap_status LIKE '%UNRESOLVABLE GAP' ORDER BY db_unique_name;
can you please tell me Is there anything that i need to be worry about ?
Thanks for your time .
Regards,
DBAPPS