dba:oracle_index_organised_table
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende Überarbeitung | ||
dba:oracle_index_organised_table [2014/08/01 10:27] – [Script für die Analyse einer IOT] gpipperr | dba:oracle_index_organised_table [2014/08/01 11:01] (aktuell) – [Script für die Analyse einer IOT] gpipperr | ||
---|---|---|---|
Zeile 139: | Zeile 139: | ||
==== Script für die Analyse einer IOT ==== | ==== Script für die Analyse einer IOT ==== | ||
- | <code sql> | + | < |
SET pagesize 300 | SET pagesize 300 | ||
SET linesize 120 | SET linesize 120 | ||
Zeile 202: | Zeile 202: | ||
from ( | from ( | ||
select nvl(i.index_name,' | select nvl(i.index_name,' | ||
- | , (select sum(bytes) from dba_segments where segment_name=i.index_name) as IndexSize | + | , (select sum(bytes) from dba_segments where segment_name=i.index_name |
, nvl(t.table_name,' | , nvl(t.table_name,' | ||
- | , nvl((select sum(bytes) from dba_segments where segment_name=t.table_name), | + | , nvl((select sum(bytes) from dba_segments where segment_name=t.table_name |
from dba_tables | from dba_tables | ||
, dba_indexes i | , dba_indexes i | ||
Zeile 225: | Zeile 225: | ||
from dba_tab_columns c | from dba_tab_columns c | ||
, dba_indexes | , dba_indexes | ||
- | where i.table_name (+) = c.table_name | + | where i.table_name (+) = c.table_name |
+ | and i.owner (+) = c.owner | ||
and upper(c.table_name) like upper('& | and upper(c.table_name) like upper('& | ||
and upper(c.owner) = upper('& | and upper(c.owner) = upper('& | ||
Zeile 232: | Zeile 233: | ||
/ | / | ||
- | ttitle | + | ttitle |
</ | </ | ||
- | |||
==== Quellen ==== | ==== Quellen ==== | ||
* http:// | * http:// | ||
* http:// | * http:// |
dba/oracle_index_organised_table.txt · Zuletzt geändert: 2014/08/01 11:01 von gpipperr