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
…