1.Performance Hub Active Report
Performance Hub feature of EM Express provides an active report with a consolidated view of all performance data for a specified time period. The report is fully interactive; its contents are saved in a HTML file, which you can access offline using a web browser.
2.Report
SQL> @@$ORACLE_HOME/rdbms/admin/perfhubrpt.SQL ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ PERFHUB ACTIVE REPORT ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ This script will generate PerfHub active report according TO ~ ~ users INPUT. The script will prompt users FOR the ~ ~ following information: ~ ~ (1) report level: basic, typical OR ALL ~ ~ (2) dbid ~ ~ (3) instance id ~ ~ (4) selected TIME range ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Specify the report level ~~~~~~~~~~~~~~~~~~~~~~~~ * Please enter basic, typical OR ALL * Report level "basic" - include tab contents but no further details * Report level "typical" - include tab contents WITH details FOR top * SQL statements * Report level "all" - include tab contents WITH details FOR ALL SQL * statements Please enter report level [typical]: USING typical FOR report level Available DATABASES AND Instances. The DATABASE WITH * IS CURRENT DATABASE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance ------------ -------- ------------ ------------ * 1399018635 1 ORCL orcl Specify the DATABASE ID ~~~~~~~~~~~~~~~~~~~~~~~ Please enter DATABASE ID [1399018635]: USING 1399018635 FOR DATABASE ID Specify the Instance NUMBER ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Single Instance DATABASE. Please press Enter DEFAULT START TIME DEFAULT END TIME AWR START TIME ------------------- ------------------- ------------------- 02/18/2015 14:42:40 02/18/2015 14:47:40 02/09/2015 20:00:33 Specify selected TIME range ~~~~~~~~~~~~~~~~~~~~~~~~~~~ * IF the selected TIME range IS IN the past HOUR, report DATA will be * retrieved FROM V$ views. * IF the selected TIME range IS OVER 1 HOUR ago, report DATA * will be retrieved FROM AWR. * IF the dbid selected IS NOT FOR the CURRENT DATABASE, ONLY AWR DATA * IS available. * * Valid INPUT formats: * TO specify absolute TIME: * [mm/dd[/yyyy]] hh24:mi[:ss] * Examples: 02/23/14 14:30:15 * 02/23 14:30:15 * 14:30:15 * 14:30 * TO specify relative TIME: (START WITH '-' sign) * -[hh24:]mi * Examples: -1:15 (SYSDATE - 1 Hr 15 Mins) * -25 (SYSDATE - 25 Mins) Please enter START TIME [02/18/2015 14:42:40]: Please enter END TIME [02/18/2015 14:47:40]: Generating report FOR 02/18/2015 14:42:40 - 02/18/2015 14:47:40 Specify the Report Name ~~~~~~~~~~~~~~~~~~~~~~~ Please enter report name [perfhub_rt_02181447.html]: Generating report perfhub_rt_02181447.html ... Report written TO perfhub_rt_02181447.html SQL> !pwd /u01/app/oracle/product/12.1.0/db_1/rdbms/admin SQL> ! [oracle@ora12102 admin]$ ls -l perfhub* -rw-r--r--. 1 oracle oinstall 20191 Feb 18 14:46 perfhubrpt.sql -rw-r--r--. 1 oracle oinstall 113369 Feb 18 14:49 perfhub_rt_02181447.html |
3.DBMS_PERF
The DBMS_PERF package provides an interface for generating database performance reports. All subprograms return an active report and these reports can be generated at the system level, session level or at SQL level.
