Database - RAC/Scalability (MOSC)

MOSC Banner

archive_dest_status shows huge elapsed time

edited Jan 14, 2015 10:04AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center