Skip to Main Content
Forums

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

AWR and RAC

Patrick JolliffeApr 9 2025 — edited Apr 9 2025

I just discovered AWR via sqlcl and I love it. Slight issue is that if I run it on a 2-node RAC system it lists each snapshot twice. I'm guessing one for each instance (maybe something else going on, but that's the simplest explanation.
I guess simplest solution would at least to include instance number on the output.
A bug IMHO.

SQL> awr list snap

SNAP_ID DBID BEGIN_INTERVAL_TIME END_INTERVAL_TIME
__________ _____________ __________________________________ __________________________________
17583 3730444841 27-FEB-25 07.00.01.804000000 PM 27-FEB-25 08.00.03.762000000 PM
17583 3730444841 27-FEB-25 07.00.01.812000000 PM 27-FEB-25 08.00.03.773000000 PM
17584 3730444841 27-FEB-25 08.00.03.773000000 PM 27-FEB-25 09.00.02.338000000 PM
17584 3730444841 27-FEB-25 08.00.03.762000000 PM 27-FEB-25 09.00.05.356000000 PM
17585 3730444841 27-FEB-25 09.00.05.356000000 PM 27-FEB-25 10.00.12.980000000 PM
17585 3730444841 27-FEB-25 09.00.02.338000000 PM 27-FEB-25 10.00.12.998000000 PM
…
Comments
Post Details
Added on Apr 9 2025
#awr, #bug
1 comment
62 views