AWR for single sql
Oracle AWR report for single sql
SQL> select DBID from v$database ;
DBID
----------
1267852645
select SNAP_ID,BEGIN_INTERVAL_TIME from dba_hist_snapshot ;
@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql
65j29t2qc8cqt
sys> @$ORACLE_HOME/rdbms/admin/awrsqrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
204677159 xxxDB 1 xxxdb
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type: text
Type Specified: text
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 204677159 1 xxxDB aptdb apt-xxxx-01
.xxxxxxxx
Using 204677159 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.
Enter value for num_days: 2
Listing the last 2 days of Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
xxxdb xxxDB 3937 17 Nov 2011 00:00 1
3938 17 Nov 2011 01:00 1
3939 17 Nov 2011 02:00 1
3940 17 Nov 2011 03:00 1
3941 17 Nov 2011 04:00 1
3942 17 Nov 2011 05:00 1
3943 17 Nov 2011 06:00 1
3944 17 Nov 2011 07:00 1
3945 17 Nov 2011 08:00 1
3946 17 Nov 2011 09:00 1
3947 17 Nov 2011 10:00 1
3948 17 Nov 2011 11:00 1
3949 17 Nov 2011 12:00 1
3950 17 Nov 2011 13:00 1
3951 17 Nov 2011 14:00 1
3952 17 Nov 2011 15:00 1
3953 17 Nov 2011 16:00 1
3954 17 Nov 2011 17:00 1
3955 17 Nov 2011 18:00 1
3956 17 Nov 2011 19:00 1
3957 17 Nov 2011 20:00 1
3958 17 Nov 2011 21:00 1
3959 17 Nov 2011 22:00 1
3960 17 Nov 2011 23:00 1
3961 18 Nov 2011 00:00 1
3962 18 Nov 2011 01:00 1
3963 18 Nov 2011 02:00 1
3964 18 Nov 2011 03:00 1
3965 18 Nov 2011 04:00 1
3966 18 Nov 2011 05:00 1
3967 18 Nov 2011 06:00 1
3968 18 Nov 2011 07:00 1
3969 18 Nov 2011 08:00 1
3970 18 Nov 2011 09:00 1
3971 18 Nov 2011 10:00 1
3972 18 Nov 2011 11:00 1
3973 18 Nov 2011 12:00 1
3974 18 Nov 2011 13:00 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 3937
Begin Snapshot Id specified: 3937
Enter value for end_snap: 3974
End Snapshot Id specified: 3974
Specify the SQL Id
~~~~~~~~~~~~~~~~~~
Enter value for sql_id: 65j29t2qc8cqt --- <<<<<<<<<<<<<<<<<<<< you have to put sql id here
