Some times it's difficult to get AWR report generated on server(os file) to local machine.
In such scenario , dbms_workload_repository package is very helpful to get the stats between 2 snapshots.
Get the snap id's from the below query,
SQL> select snap_id,DBID,STARTUP_TIME,BEGIN_INTERVAL_TIME,END_INTERVAL_TIME from dba_hist_snapshot order by 1;
SNAP_ID DBID STARTUP_TIME BEGIN_INTERVAL_TIME END_INTERVAL_TIME
---------- ---------- -------------------------------------------------- ---------------------------------------- --------------------------------------
145 1409006025 08-JUL-15 06.50.28.000 PM 11-JUL-15 05.04.57.108 PM 11-JUL-15 06.30.04.448 PM
146 1409006025 08-JUL-15 06.50.28.000 PM 11-JUL-15 06.30.04.448 PM 13-JUL-15 07.15.19.101 PM
147 1409006025 08-JUL-15 06.50.28.000 PM 13-JUL-15 07.15.19.101 PM 13-JUL-15 08.30.15.291 PM
148 1409006025 08-JUL-15 06.50.28.000 PM 13-JUL-15 08.30.15.291 PM 14-JUL-15 05.14.46.667 PM
149 1409006025 08-JUL-15 06.50.28.000 PM 14-JUL-15 05.14.46.667 PM 14-JUL-15 06.58.34.847 PM
150 1409006025 08-JUL-15 06.50.28.000 PM 14-JUL-15 06.58.34.847 PM 14-JUL-15 07.30.36.378 PM
151 1409006025 08-JUL-15 06.50.28.000 PM 14-JUL-15 07.30.36.378 PM 14-JUL-15 08.30.41.850 PM
152 1409006025 08-JUL-15 06.50.28.000 PM 14-JUL-15 08.30.41.850 PM 15-JUL-15 05.33.56.291 PM
153 1409006025 08-JUL-15 06.50.28.000 PM 15-JUL-15 05.33.56.291 PM 15-JUL-15 06.30.59.949 PM
154 1409006025 08-JUL-15 06.50.28.000 PM 15-JUL-15 06.30.59.949 PM 15-JUL-15 07.30.05.933 PM
155 1409006025 08-JUL-15 06.50.28.000 PM 15-JUL-15 07.30.05.933 PM 17-JUL-15 08.12.36.813 PM
156 1409006025 08-JUL-15 06.50.28.000 PM 17-JUL-15 08.12.36.813 PM 17-JUL-15 10.41.56.466 PM
157 1409006025 08-JUL-15 06.50.28.000 PM 17-JUL-15 10.41.56.466 PM 18-JUL-15 09.10.22.083 AM
158 1409006025 08-JUL-15 06.50.28.000 PM 18-JUL-15 09.10.22.083 AM 18-JUL-15 01.04.56.517 PM
159 1409006025 08-JUL-15 06.50.28.000 PM 18-JUL-15 01.04.56.517 PM 18-JUL-15 07.12.11.169 PM
161 1409006025 08-JUL-15 06.50.28.000 PM 19-JUL-15 06.07.32.800 PM 20-JUL-15 06.45.12.359 PM
Run the DBMS_WORKLOAD_REPOSITRY. awr_report_text package to get the awr report
SELECT output
FROM TABLE (dbms_workload_repository.awr_report_text(
l_dbid=>1409006025,
l_inst_num=>1,
l_bid=>150,
l_eid=>153
)
);
In such scenario , dbms_workload_repository package is very helpful to get the stats between 2 snapshots.
Get the snap id's from the below query,
SQL> select snap_id,DBID,STARTUP_TIME,BEGIN_INTERVAL_TIME,END_INTERVAL_TIME from dba_hist_snapshot order by 1;
SNAP_ID DBID STARTUP_TIME BEGIN_INTERVAL_TIME END_INTERVAL_TIME
---------- ---------- -------------------------------------------------- ---------------------------------------- --------------------------------------
145 1409006025 08-JUL-15 06.50.28.000 PM 11-JUL-15 05.04.57.108 PM 11-JUL-15 06.30.04.448 PM
146 1409006025 08-JUL-15 06.50.28.000 PM 11-JUL-15 06.30.04.448 PM 13-JUL-15 07.15.19.101 PM
147 1409006025 08-JUL-15 06.50.28.000 PM 13-JUL-15 07.15.19.101 PM 13-JUL-15 08.30.15.291 PM
148 1409006025 08-JUL-15 06.50.28.000 PM 13-JUL-15 08.30.15.291 PM 14-JUL-15 05.14.46.667 PM
149 1409006025 08-JUL-15 06.50.28.000 PM 14-JUL-15 05.14.46.667 PM 14-JUL-15 06.58.34.847 PM
150 1409006025 08-JUL-15 06.50.28.000 PM 14-JUL-15 06.58.34.847 PM 14-JUL-15 07.30.36.378 PM
151 1409006025 08-JUL-15 06.50.28.000 PM 14-JUL-15 07.30.36.378 PM 14-JUL-15 08.30.41.850 PM
152 1409006025 08-JUL-15 06.50.28.000 PM 14-JUL-15 08.30.41.850 PM 15-JUL-15 05.33.56.291 PM
153 1409006025 08-JUL-15 06.50.28.000 PM 15-JUL-15 05.33.56.291 PM 15-JUL-15 06.30.59.949 PM
154 1409006025 08-JUL-15 06.50.28.000 PM 15-JUL-15 06.30.59.949 PM 15-JUL-15 07.30.05.933 PM
155 1409006025 08-JUL-15 06.50.28.000 PM 15-JUL-15 07.30.05.933 PM 17-JUL-15 08.12.36.813 PM
156 1409006025 08-JUL-15 06.50.28.000 PM 17-JUL-15 08.12.36.813 PM 17-JUL-15 10.41.56.466 PM
157 1409006025 08-JUL-15 06.50.28.000 PM 17-JUL-15 10.41.56.466 PM 18-JUL-15 09.10.22.083 AM
158 1409006025 08-JUL-15 06.50.28.000 PM 18-JUL-15 09.10.22.083 AM 18-JUL-15 01.04.56.517 PM
159 1409006025 08-JUL-15 06.50.28.000 PM 18-JUL-15 01.04.56.517 PM 18-JUL-15 07.12.11.169 PM
161 1409006025 08-JUL-15 06.50.28.000 PM 19-JUL-15 06.07.32.800 PM 20-JUL-15 06.45.12.359 PM
Run the DBMS_WORKLOAD_REPOSITRY. awr_report_text package to get the awr report
SELECT output
FROM TABLE (dbms_workload_repository.awr_report_text(
l_dbid=>1409006025,
l_inst_num=>1,
l_bid=>150,
l_eid=>153
)
);
No comments:
Post a Comment