Oracle11gr1 getting started Tutorial: ASH usage

ASH uses SQLgt ;@? Rdbmsadminashrpt. sqlCurrentInstance ~~~~~~~~~~~~~~~~ DBIdDBNameInstNumInstance ---------

ASH uses SQLgt ;@? /Rdbms/admin/ashrpt. SQL Current Instance ~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance ---------

ASH usage
SQL>@? /Rdbms/admin/ashrpt. SQL

Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
-------------------------------------------
450641661 SUBSDB 1 subsdb

Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Enter 'html' for an html report, or 'text' for plain text
Ults to 'html'
Enter value for report_type:Html
Type Specified: html

Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~
DB Id Inst Num DB Name Instance Host
--------------------------------------------------------
* 450641661 1 SUBSDB subsdb subsdb2
* 450641661 1 SUBSDB subsdb subsdb1

Ults to current database
Using database id: 450641661
Ults to current instance
Using instance number: 1

ASH Samples in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~
Oldest ASH sample available: 27-Sep-11 09:40:25 [7470 mins in the past]
Latest ASH sample available: 02-Oct-11 14:10:33 [0 mins in the past]
Specify the timeframe to generate the ASH report
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~
Enter begin time for report:
-- Valid input formats:
-- To specify absolute begin time:
-- [MM/DD [/YY] HH24: MI [: SS]
-- Examples: 02/23/03 14:30:15
-- 14:30:15, 02/23
-- 14:30:15
-- 14: 30
-- To specify relative begin time: (start with '-' sign)
-- [HH24:] MI
-- Examples:-(SYSDATE-1 Hr 15 Mins)
---25 (SYSDATE-25 Mins)
Defaults to-15 mins
Enter value for begin_time:10/02/11 08:30:00
Report begin time specified: 10/02/11 08:30:00
Enter duration in minutes starting from begin time:
Defaults to SYSDATE-begin_time
Press Enter to analyze till current time
Enter value for duration:30
Report duration specified: 30
Note: The reporting period of the hit ash is from, 2011-10-02 to, 2011-10-02.

Using 02-Oct-11 08:30:00 as report begin time
Using 02-Oct-11 09:00:00 as report end time

Specify Slot Width (using ashrpti. SQL) for 'activity Over time' section
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-- Explanation:
-- In the 'Activity Over time' section of the ASH report,
-- The analysis period is pided into smaller slots
-- And top wait events are reported in each of those slots.
-- Default:
-- The analysis period will be automatically split upto 10 slots
-- Complying to a minimum slot width
-- 1 minute, if the source is V $ ACTIVE_SESSION_HISTORY or
-- 5 minutes, if the source is DBA_HIST_ACTIVE_SESS_HISTORY.
Specify Slot Width in seconds to use in the 'Activity Over time' section:
Defaults to a value as fig:
Slot Width specified:
Specify Report Targets (using ashrpti. SQL) to generate the ASH report
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-- Explanation:
-- ASH Report can accept "Report Targets ",
-- Like a participant SQL statement, or a participant SESSION,
-- To generate the report on. If one or more report targets are
-- Specified, then the data used to generate the report will only be
-- The ASH samples that pertain to ALL the specified report targets.
-- Default:
-- If none of the report targets are specified,
-- Then the target defaults to all activity in the database instance.
Specify SESSION_ID (eg: from V $ SESSION. SID) report target:
Defaults to NULL:
SESSION report target specified:
Specify SQL _ID (eg: from V $ SQL. SQL _ID) report target:
Defaults to NULL: (% and _ wildcards allowed)
SQL report target specified:
Specify WAIT_CLASS name (eg: from V $ EVENT_NAME.WAIT_CLASS) report target:
[Enter 'cpu 'to ststigate CPU usage]
Defaults to NULL: (% and _ wildcards allowed)
WAIT_CLASS report target specified:
Specify SERVICE_HASH (eg: from V $ ACTIVE_SERVICES.NAME_HASH) report target:
Defaults to NULL:
SERVICE report target specified:
Specify MODULE name (eg: from V $ SESSION. MODULE) report target:
Defaults to NULL: (% and _ wildcards allowed)
MODULE report target specified:
Specify ACTION name (eg: from V $ SESSION. ACTION) report target:
Defaults to NULL: (% and _ wildcards allowed)
ACTION report target specified:
Specify CLIENT_ID (eg: from V $ SESSION. CLIENT_IDENTIFIER) report target:
Defaults to NULL: (% and _ wildcards allowed)
CLIENT_ID report target specified:
Specify PLSQL_ENTRY name (eg: "SYS. DBMS_LOB. *") report target:
Defaults to NULL: (% and _ wildcards allowed)
PLSQL_ENTRY report target specified:

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is ashrpt_00001002_0900.html. To use this name,
Press To continue, otherwise enter an alternative.
Enter value for report_name: /Home/Oracle/ash_rpt_20111002_8: 30-9:00. html

Using the report name/home/oracle/ash_rpt_20111002_8: 30-9:00. html

Summary of All User Input
-------------------------
Format: HTML
DB Id: 450641661
Inst num: 1
Begin time: 02-Oct-11 08:30:00
End time: 02-Oct-11 09:00:00
Slot width: Default
Report targets: 0
Report name:/home/oracle/ash_rpt_20111002_8: 30-9:00. html

,