Frequently Asked Questions
Performance Hub active reports can be generated directly from the EM Express live UI. Just navigate to the Performance Hub and click the Save button at the top of the page; this will issue a request to the database. Once the data has been retrieved, the user will be prompted for a location and filename; the user can now click OK and save the report locally.
Alternatively, an active report can be generated by directly invoking the PL/SQL procedure dbms_perf.report_perfhub_xml() using "active" as the report type. For example, the following SQL*Plus script shows you how to generate a realtime PerfHub active report:
set pages 0 linesize 32767 trimspool on trim on long 1000000 longchunksize 10000000 spool perfhub_active.html select dbms_perf.report_perfhub(is_realtime=>1,type=>'active') from dual; spool off
The resulting file perfhub_active.html should be edited to remove the header (first line in the file) and the last line (spool off). The HTML file can now be viewed in any browser, provided the browser can connect to OTN to load the UI code needed to render the active report.
EM Express allows users to save composite active reports for SQL Details, Session Details and SQL Monitor List.
The SQL Details active report has been significantly revamped in DB12. Like the Performance Hub active report, it can be generated by clicking the Save button from the UI, or from SQL*Plus using the dbms_perf.report_sql() function.
The Session Details active report can also be generated from the UI, or from SQL*Plus using the dbms_perf.report_session() function.
The SQL Monitor List is already part of the Performance Hub. To generate a standalone SQL Monitor list active report, use the dbms_sqltune.report_sql_monitor_list() function.
An Automatic Real Time ADDM report can be viewed and saved on its own. However, since it is essentially a PerfHub active report, the report, when opened, will display "Performance Hub" in its title instead of Automatic Real Time ADDM.
Click on the "Show Report Details" button at the top of the active report. This will show additional information about the report such as database name, instance name, host name and the time frame for the report.
Although the Composite Active Report contains large amounts of data, the actual size of the report is fairly small; a typical active report of the Performance Hub is usually in the 300KB-400KB range. The small size of the active reports is achieved using data compression.
The SPA and SQL Monitor Details active reports, which were introduced in 11g, have also been enhanced.
Yes, but not from EM Express; there is no Mail button. However, you can save the active report locally, and then email the HTML file as an attachment.
You can only save active reports for features that are already covered by the Diagnostics and Tuning packs.
If you want to save the active report for a given time range, use the timepicker to select a time range before saving the active report. Now when the active report is generated, it will save data for the selected time range.