Performance Hub Active Report in oracle

Performance Hub Active Report

This is the script to generate perfhub active report.

@$ORACLE_HOME/rdbms/admin/perfhubrpt.sql

Example:

SQL> @D:\Oracle\18.0.0\dbhomeXE\rdbms\admin\perfhubrpt;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ 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]:

Available Databases and Instances.
The database with * is current database
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DB Id DB Name AWR Data Source Type
------------ ------------ ------------------------ ------------------------
* 2882898177 XE CDB$ROOT CDB

Specify the database ID
~~~~~~~~~~~~~~~~~~~~~~~
Please enter database ID [2882898177]:

Using 2882898177 for database ID

Please specify the container name for which to generate the report

List of available open container(s):

Note: Upto 10 open container(s) on this instance are displayed below.
Enter a valid container name.

Container Name Container DBID Type
------------------------ -------------- ------------------------
* CDB$ROOT 2882898177 CDB
XEPDB1 3053402371 PDB

Please enter container name: XEPDB1

Using XEPDB1 for container name

Specify the Instance Number
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Single Instance Database. Please press Enter

Default Start Time Default End Time Oldest Available Snapshot Time
------------------- ------------------- ------------------------------
05/14/2019 15:32:11 05/14/2019 15:37:11 05/04/2019 19:55:10

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 [05/14/2019 15:32:11]: -4

Please enter end time [05/14/2019 15:37:11]:

Generating report for 05/14/2019 15:34:25 - 05/14/2019 15:37:11

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
Please enter report name [perfhub_rt_05141537.html]: E:\perfhub.html

Generating report E:\perfhub.html ...

Report written to E:\perfhub.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.