Hi. I'm trying to generate an AWR report on Oracle 11g RAC. The report is generated, but the db time is 0.00, and a lot of the sections are empty (showing "No data exists for this section of the report.") even though there is supposed to be data.
AFAIK the machine is set up without any special flags or configurations. It contains of two nodes, and running awrrpt on both them yields the same results.
I've attached a sample report. Even though it only spans one minute some actions were done on the database, so it should have shown some statistics. The same problem persists with a report generated over several hours with tens of thousands of select and update commands. Still, the DB time is 0 and the SQL section is empty, as well as most other sections.
Is there a flag I need to turn on (or anything else) to generate the required statistics?