dba:awr_manual_reporting
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende ÜberarbeitungLetzte ÜberarbeitungBeide Seiten der Revision | ||
dba:awr_manual_reporting [2015/10/17 15:27] – [AWR Berichtsaufruf] gpipperr | dba:awr_manual_reporting [2015/10/20 11:01] – [Quellen] gpipperr | ||
---|---|---|---|
Zeile 115: | Zeile 115: | ||
- | === ASH Report aufrufen === | + | ==== ASH Report aufrufen |
Mit der gleichen Methodik kann einfach auch ein ASH Bericht aufgerufen werden, dazu Funktion ASH_REPORT_HTML aufrufen. | Mit der gleichen Methodik kann einfach auch ein ASH Bericht aufgerufen werden, dazu Funktion ASH_REPORT_HTML aufrufen. | ||
Zeile 122: | Zeile 122: | ||
+ | <code sql awr_call_ash_report.sql> | ||
+ | |||
+ | prompt | ||
+ | prompt !!!!You need the Tuning Pack for this feature!!!! | ||
+ | prompt | ||
+ | |||
+ | |||
+ | -- ===== | ||
+ | -- get the spoolfile name and instance_number + DB ID | ||
+ | -- ===== | ||
+ | set feedback off | ||
+ | set heading off | ||
+ | set termout off | ||
+ | |||
+ | column spool_name_col new_val spool_name | ||
+ | column instance_number new_val inst_nr | ||
+ | column aktdbid new_val databaseid | ||
+ | |||
+ | SELECT replace(ora_database_name||' | ||
+ | --' resolve syntax highlight bug FROM my editer .-( | ||
+ | AS SPOOL_NAME_COL | ||
+ | , | ||
+ | FROM dual | ||
+ | / | ||
+ | |||
+ | select dbid as aktdbid | ||
+ | from v$database | ||
+ | / | ||
+ | |||
+ | set feedback on | ||
+ | set heading on | ||
+ | set termout on | ||
+ | |||
+ | -- ===== | ||
+ | -- ask for the Start and endtime of the report | ||
+ | -- ===== | ||
+ | set verify off | ||
+ | |||
+ | SET linesize 120 pagesize 300 recsep off | ||
+ | |||
+ | define TIME_FORMAT=' | ||
+ | |||
+ | column min_start_time format a18 heading "Early Start|Date" | ||
+ | column max_start_time format a18 heading " | ||
+ | |||
+ | ttitle left " | ||
+ | |||
+ | select to_char(min(s.sample_time),'&& | ||
+ | , to_char(max(s.sample_time),'&& | ||
+ | from dba_hist_active_sess_history s | ||
+ | | ||
+ | | ||
+ | / | ||
+ | |||
+ | -- | ||
+ | -- fix and snap_id in (... ) like seelect | ||
+ | -- | ||
+ | ttitle off | ||
+ | |||
+ | accept l_btime date prompt 'Enter start time (format && | ||
+ | accept l_etime date prompt 'Enter end time | ||
+ | |||
+ | |||
+ | -- ===== | ||
+ | -- create the ASH Report | ||
+ | -- ===== | ||
+ | |||
+ | |||
+ | SET linesize 500 pagesize 9000 recsep off | ||
+ | set long 64000 | ||
+ | set feedback off | ||
+ | set heading off | ||
+ | |||
+ | spool && | ||
+ | |||
+ | select * | ||
+ | from table(sys.dbms_workload_repository.ash_report_html( && | ||
+ | , && | ||
+ | , to_date('&& | ||
+ | , to_date('&& | ||
+ | ) | ||
+ | ) | ||
+ | / | ||
+ | |||
+ | spool off | ||
+ | set heading on | ||
+ | set feedback on | ||
+ | |||
+ | prompt ... check the created report | ||
+ | |||
+ | host && | ||
+ | |||
+ | set linesize 130 pagesize 300 recsep off | ||
+ | |||
+ | </ | ||
==== Quellen ==== | ==== Quellen ==== | ||
Zeile 133: | Zeile 228: | ||
+ | Übersicht ASH | ||
+ | * http:// | ||
dba/awr_manual_reporting.txt · Zuletzt geändert: 2021/02/18 11:33 von gpipperr