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
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()
The Session Details active report can also be generated
from the UI, or from SQL*Plus using the dbms_perf.report_session()
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()
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
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.