Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

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
1 comment
111 views