1 person found this helpful
I saw 'ASH Report Viewer' issuing following command, so obviously it will not work on RAC. This is probably a bug, it works well in single instance.
SELECT output FROM TABLE (DBMS_WORKLOAD_REPOSITORY.ash_report_html ( (SELECT dbid FROM gv$database), (SELECT inst_id FROM gv$database), :BEGIN_TIME, :END_TIME, 0, 0, :SID, :SQL_ID, :WAIT_CLASS, :SERVICE_HASH, :MODULE, :ACTION, :CLIENT_ID))
Thanks for checking. I'll have to add this to the bug list.
Thanks, I guess it is the same problem in most ASH/AWR error cases, they select from GV$
Bugged - thanks for the report!