Heim > Datenbank > MySQL-Tutorial > Hauptteil

Oracle 11g r1入门教程:ASH使用

WBOY
Freigeben: 2016-06-07 17:06:00
Original
837 Leute haben es durchsucht

ASH使用SQLgt; @?/rdbms/admin/ashrpt.sql Current Instance~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance---------

ASH使用
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
Defaults 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

Defaults to current database
Using database id: 450641661
Defaults 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
--      02/23 14:30:15
--      14:30:15
--      14:30
-- To specify relative begin time: (start with '-' sign)
--   -[HH24:]MI
--   Examples: -1:15  (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
说明:打的ash报告时间段是从2011-10-02 8:30至2011-10-02 9:00。

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 divided 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 of
--     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 explained above:
Slot Width specified:
Specify Report Targets (using ashrpti.sql) to generate the ASH report
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-- Explanation:
--   ASH Report can accept "Report Targets",
--   like a particular SQL statement, or a particular 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 investigate 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_1_1002_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

linux

Verwandte Etiketten:
Quelle:php.cn
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Beliebte Tutorials
Mehr>
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage