dba:sql_baseline
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende Überarbeitung | ||
dba:sql_baseline [2015/03/11 10:46] – [Quellen] gpipperr | dba:sql_baseline [2015/03/11 10:48] (aktuell) – [Die vorhandenen Baselines anzeigen] gpipperr | ||
---|---|---|---|
Zeile 3: | Zeile 3: | ||
< | < | ||
+ | |||
+ | |||
+ | ===Die vorhandenen Baselines anzeigen=== | ||
+ | |||
+ | <code bash> | ||
+ | SET pagesize 1000 | ||
+ | SET linesize 150 | ||
+ | |||
+ | column SQL_TEXT format a23 | ||
+ | column SQL_HANDLE format a20 | ||
+ | column PARSING_SCHEMA_NAME format a14 | ||
+ | column PLAN_NAME format a30 | ||
+ | column ORIGIN format a16 | ||
+ | column CREATED_TEXT format a18 | ||
+ | column ENABLED format a3 heading " | ||
+ | column ACCEPTED format a3 heading " | ||
+ | |||
+ | |||
+ | select | ||
+ | , replace(replace(substr(SQL_TEXT, | ||
+ | , PARSING_SCHEMA_NAME | ||
+ | , PLAN_NAME | ||
+ | , ORIGIN | ||
+ | , to_char(CREATED,' | ||
+ | , ENABLED | ||
+ | , ACCEPTED | ||
+ | from DBA_SQL_PLAN_BASELINES | ||
+ | order by CREATED | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | === Die Pläne in einer Baseline anzeigen === | ||
+ | |||
+ | Mit der Format **format | ||
+ | <code bash> | ||
+ | set long 10000 | ||
+ | |||
+ | define SQL_BASELINE_PLAN=& | ||
+ | |||
+ | prompt | ||
+ | prompt Parameter 1 = SQL_BASELINE_PLAN | ||
+ | prompt | ||
+ | |||
+ | select * | ||
+ | from table(dbms_xplan.display_sql_plan_baseline( plan_name=>'&& | ||
+ | , | ||
+ | ) | ||
+ | / | ||
+ | |||
+ | select * | ||
+ | from table(dbms_xplan.display_sql_plan_baseline( plan_name=>'&& | ||
+ | , | ||
+ | ) | ||
+ | / | ||
+ | </ | ||
==== Quellen ==== | ==== Quellen ==== |
dba/sql_baseline.txt · Zuletzt geändert: 2015/03/11 10:48 von gpipperr