Download AC-Toolbar Oracle Schulung und Consulting

Eigenartiges Verhalten des Optimizers Teil2

Benutzerbewertung: / 478
SchwachPerfekt 
Geschrieben von: Marek Adar   

Nach Auftreten des im vorherigen Artikel beschriebenen Problems mit Histogrammen, habe ich versucht dieses Problem mit einem eigenen Skript zu reproduzieren. Dieses Skript kann hier heruntergeladen werden.


Hierfür erstellte ich folgende Tabelle:

SQL> CREATE TABLE TESTTAB1 (S1 NUMBER,S2 VARCHAR2(100),
2  S3 VARCHAR2(100), S4 VARCHAR2(1000)) TABLESPACE USERS;

Tabelle wurde erstellt.

In diese Tabelle fügte ich dann mit 100000 Datensätze ein, wobei die Spalte s4 mit 1000 Zeichen befüllt wurde, die sich aber nur in den letzten 6 Zeichen unterschieden.

SQL> BEGIN
2  FOR I IN 1..1000000
3  LOOP
4  INSERT INTO TESTTAB1 VALUES(I, 'DAS IST  EIN LANGER WERT ' || I, 'DAS IST EIN LANGER WERT ' || I,
5  LPAD(TO_CHAR(I),1000,'X'));
6  END LOOP;
7  COMMIT;
8  END;
9  /

PL/SQL-Prozedur erfolgreich abgeschlossen.

Im nächsten Schritt wurde ein Index auf die Spalte s4 erstellt und die Statistiken gesammelt.

SQL> CREATE INDEX IDX_TESTTAB1 ON TESTTAB1(S4) TABLESPACE USERS;

Index wurde erstellt.

SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS(USER,'TESTTAB1',CASCADE=>TRUE)

PL/SQL-Prozedur erfolgreich abgeschlossen.

Nach Erstellung von Index und Statistiken wurde dann ein Wert aus der Tabelle selektiert. Interessanterweise verwendete Oracle nun den Index.

SQL> SET AUTOTRACE TRACEONLY
SQL> SELECT * FROM TESTTAB1 WHERE S4=LPAD('111',1000,'X');

Ausfuhrungsplan
----------------------------------------------------------
PLAN HASH VALUE: 1964488939

--------------------------------------------------------------------------------------------
| ID  | OPERATION                   | NAME         | ROWS  | BYTES | COST (%CPU)| TIME     |
--------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |              |  1    |  1070 |  8   (0)   | 00:00:01 |
|   1 |  TABLE ACCESS BY INDEX ROWID| TESTTAB1     |  1    |  1070 |  8   (0)   | 00:00:01 |
|*  2 |   INDEX RANGE SCAN          | IDX_TESTTAB1 |  1    |       |  7   (0)   | 00:00:01 |
--------------------------------------------------------------------------------------------

PREDICATE INFORMATION (IDENTIFIED BY OPERATION ID):
---------------------------------------------------

2 - ACCESS("S4"='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXX111')

STATISTIKEN
----------------------------------------------------------
   0  RECURSIVE CALLS
   0  DB BLOCK GETS
   9  CONSISTENT GETS
   0  PHYSICAL READS
   0  REDO SIZE
1791  BYTES SENT VIA SQL*NET TO CLIENT
 523  BYTES RECEIVED VIA SQL*NET FROM CLIENT
   2  SQL*NET ROUNDTRIPS TO/FROM CLIENT
   0  SORTS (MEMORY)
   0  SORTS (DISK)
   1  ROWS PROCESSED

Als nächstes leerte ich den Shared Pool und erzeugte die Statistiken auf gleicher Art und Weise neu.
Bei erneuter Ausführung der SQL-Anweisung wurde nun der Index ignoriert.

SQL> ALTER SYSTEM FLUSH SHARED_POOL;

System wurde geandert.

SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS(USER,'TESTTAB1',CASCADE=>TRUE)

PL/SQL-Prozedur erfolgreich abgeschlossen.

SQL> SELECT * FROM TESTTAB1 WHERE S4=LPAD('111',1000,'X');

ausfuhrungsplan
----------------------------------------------------------
PLAN HASH VALUE: 3404082979

------------------------------------------------------------------------------
| ID  | OPERATION         | NAME     |  ROWS| BYTES| COST (%CPU)| TIME       |
------------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |          |  999K| 1020M| 46591   (1)| 00:09:20   |
|*  1 |  TABLE ACCESS FULL| TESTTAB1 |  999K| 1020M| 46591   (1)| 00:09:20   |
------------------------------------------------------------------------------

PREDICATE INFORMATION (IDENTIFIED BY OPERATION ID):
---------------------------------------------------

1 - FILTER("S4"='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXX111')

STATISTIKEN
----------------------------------------------------------
     0  RECURSIVE CALLS
     1  DB BLOCK GETS
167560  CONSISTENT GETS
166904  PHYSICAL READS
     0  REDO SIZE
  1784  BYTES SENT VIA SQL*NET TO CLIENT
   523  BYTES RECEIVED VIA SQL*NET FROM CLIENT
     2  SQL*NET ROUNDTRIPS TO/FROM CLIENT
     0  SORTS (MEMORY)
     0  SORTS (DISK)
     1  ROWS PROCESSED

Beim Zwingen zur Verwendung des Indexes konnte man nun sehen, dass die Kosten extrem anstiegen, die Anzahl der gelesenen Blöcke aber drastisch sank.

SQL> SELECT /*+ INDEX(TESTTAB1 IDX_TESTTAB1) */ * FROM TESTTAB1 WHERE S4=LPAD('111',1000,'X');

Ausfuhrungsplan
----------------------------------------------------------
PLAN HASH VALUE: 1964488939

--------------------------------------------------------------------------------------------
| ID  | OPERATION                   | NAME        | ROWS  | BYTES | COST (%CPU)| TIME      |
--------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |             |   999K|  1020M|   427K  (1)| 01:25:33  |
|   1 |  TABLE ACCESS BY INDEX ROWID| TESTTAB1    |   999K|  1020M|   427K  (1)| 01:25:33  |
|*  2 |   INDEX RANGE SCAN          | IDX_TESTTAB1|   999K|       |   142K  (1)| 00:28:35  |
--------------------------------------------------------------------------------------------

PREDICATE INFORMATION (IDENTIFIED BY OPERATION ID):
---------------------------------------------------

2 - ACCESS("S4"='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXX111')

STATISTIKEN
----------------------------------------------------------
   1  RECURSIVE CALLS
   0  DB BLOCK GETS
   9  CONSISTENT GETS
   0  PHYSICAL READS
   0  REDO SIZE
1791  BYTES SENT VIA SQL*NET TO CLIENT
 523  BYTES RECEIVED VIA SQL*NET FROM CLIENT
   2  SQL*NET ROUNDTRIPS TO/FROM CLIENT
   0  SORTS (MEMORY)
   0  SORTS (DISK)
   1  ROWS PROCESSED

Bei Überprüfung des Histogramms für die Spalte S4 wurde nun die Ursache klar, denn es wurde nur ein Bucket innerhalb der Wertebereichs für die Spalte S4 erstellt, wodurch Oracle davon ausgehen musste, dass alle Werte der Spalte S4 identisch sind und somit die Verwendung eines Index keinen Sinn macht.

SQL> SELECT COLUMN_NAME,ENDPOINT_NUMBER, ENDPOINT_VALUE
2  FROM DBA_HISTOGRAMS
3  WHERE OWNER=USER AND TABLE_NAME='TESTTAB1' AND
4  COLUMN_NAME='S4';

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         5458            4,5871E+35

1 Zeile ausgewahlt.

Auch beim manuellen Erzeugen von Histogrammen ignoriert Oracle den Index, weil diese nicht richtig berechnet wurden.

SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS(USER,'TESTTAB1',CASCADE=>TRUE, METHOD_OPT=>'FOR ALL COLUMNS SIZE AUTO FOR COLUMNS S4 SIZE 200')

PL/SQL-Prozedur erfolgreich abgeschlossen.

SQL> SELECT COLUMN_NAME,ENDPOINT_NUMBER, ENDPOINT_VALUE
2  FROM DBA_HISTOGRAMS
3  WHERE OWNER=USER AND TABLE_NAME='TESTTAB1' AND
4  COLUMN_NAME='S4';

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         5458            4,5871E+35

1 Zeile ausgewahlt.

Im nächsten Schritt löschte ich die Statistiken, um das Dynamic Sampling zu verwenden und siehe da, der Index wird verwendet.

SQL> EXEC DBMS_STATS.DELETE_TABLE_STATS(USER,'TESTTAB1')

PL/SQL-Prozedur erfolgreich abgeschlossen.

SQL> SELECT * FROM TESTTAB1 WHERE S4=LPAD('111',1000,'X');

Ausfuhrungsplan
----------------------------------------------------------
Plan hash value: 1964488939

--------------------------------------------------------------------------------------------
| Id  | Operation                   | Name         | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |              |  1    |   619 |  3      (0)| 00:00:01 |
|   1 |  TABLE ACCESS BY INDEX ROWID| TESTTAB1     |  1    |   619 |  3      (0)| 00:00:01 |
|*  2 |   INDEX RANGE SCAN          | IDX_TESTTAB1 |  1    |       |  1      (0)| 00:00:01 |
--------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

 

2 - access("S4"='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXX111')

 Note
-----
- dynamic sampling used for this statement (level=2)

 Statistiken
----------------------------------------------------------
     0  recursive calls
     1  db block gets
167432  consistent gets
166788  physical reads
     0  redo size
  1783  bytes sent via SQL*Net to client
   523  bytes received via SQL*Net from client
     2  SQL*Net roundtrips to/from client
     0  sorts (memory)
     0  sorts (disk)
     1  rows processed

Wurden die Werte der Spalte s4 so modifiziert, dass die führenden X-Zeichen entfernt wurden, so wurden die Histogramme ordnungsgemäß berechnet und der Optimizer die Verwendung des Index vorschlug.

SQL> UPDATE TESTTAB1 SET S4=REPLACE(S4,'X','');

1000000 Zeilen wurden aktualisiert.

SQL> COMMIT;

Transaktion mit Commit abgeschlossen.

SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS(USER,'TESTTAB1',CASCADE=>TRUE, METHOD_OPT=>'FOR COLUMNS S4 SIZE 250')

PL/SQL-Prozedur erfolgreich abgeschlossen.

SQL> SELECT COLUMN_NAME,ENDPOINT_NUMBER, ENDPOINT_VALUE
2  FROM DBA_HISTOGRAMS
3  WHERE OWNER=USER AND TABLE_NAME='TESTTAB1' AND
4  COLUMN_NAME='S4';

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         236     2,9704E+35
S4         237     2,9704E+35
S4         238     2,9706E+35
S4         239     2,9706E+35
S4         240     2,9706E+35
S4         241     2,9708E+35
S4         242     2,9708E+35
S4         243     2,9708E+35
S4         244     2,9710E+35
S4         245     2,9710E+35
S4         246     2,9710E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         247     2,9710E+35
S4         248     2,9712E+35
S4         249     2,9712E+35
S4         250     2,9712E+35
S4    0     2,5540E+35
S4    1     2,5540E+35
S4    2     2,5540E+35
S4    3     2,5542E+35
S4    4     2,5542E+35
S4    5     2,5542E+35
S4    6     2,5544E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4    7     2,5544E+35
S4    8     2,5546E+35
S4    9     2,5546E+35
S4   10     2,5546E+35
S4   11     2,5548E+35
S4   12     2,5548E+35
S4   13     2,5548E+35
S4   14     2,5550E+35
S4   15     2,5550E+35
S4   16     2,5552E+35
S4   17     2,5552E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4   18     2,5552E+35
S4   19     2,5554E+35
S4   20     2,5554E+35
S4   21     2,5556E+35
S4   22     2,5556E+35
S4   23     2,5556E+35
S4   24     2,5558E+35
S4   25     2,5558E+35
S4   26     2,5558E+35
S4   27     2,5558E+35
S4   28     2,6059E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4   29     2,6059E+35
S4   30     2,6061E+35
S4   31     2,6061E+35
S4   32     2,6061E+35
S4   33     2,6063E+35
S4   34     2,6063E+35
S4   35     2,6063E+35
S4   36     2,6065E+35
S4   37     2,6065E+35
S4   38     2,6067E+35
S4   39     2,6067E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4   40     2,6069E+35
S4   41     2,6069E+35
S4   42     2,6069E+35
S4   43     2,6071E+35
S4   44     2,6071E+35
S4   45     2,6071E+35
S4   46     2,6073E+35
S4   47     2,6073E+35
S4   48     2,6073E+35
S4   49     2,6075E+35
S4   50     2,6075E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4   51     2,6076E+35
S4   52     2,6077E+35
S4   53     2,6078E+35
S4   54     2,6578E+35
S4   55     2,6578E+35
S4   56     2,6578E+35
S4   57     2,6579E+35
S4   58     2,6581E+35
S4   59     2,6581E+35
S4   60     2,6583E+35
S4   61     2,6583E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4   62     2,6585E+35
S4   63     2,6585E+35
S4   64     2,6585E+35
S4   65     2,6585E+35
S4   66     2,6587E+35
S4   67     2,6587E+35
S4   68     2,6587E+35
S4   69     2,6589E+35
S4   70     2,6589E+35
S4   71     2,6591E+35
S4   72     2,6591E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4   73     2,6593E+35
S4   74     2,6593E+35
S4   75     2,6593E+35
S4   76     2,6595E+35
S4   77     2,6595E+35
S4   78     2,6597E+35
S4   79     2,6597E+35
S4   80     2,6597E+35
S4   81     2,7098E+35
S4   82     2,7098E+35
S4   83     2,7100E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4   84     2,7100E+35
S4   85     2,7100E+35
S4   86     2,7102E+35
S4   87     2,7102E+35
S4   88     2,7102E+35
S4   89     2,7104E+35
S4   90     2,7104E+35
S4   91     2,7104E+35
S4   92     2,7106E+35
S4   93     2,7106E+35
S4   94     2,7108E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4   95     2,7108E+35
S4   96     2,7110E+35
S4   97     2,7110E+35
S4   98     2,7110E+35
S4   99     2,7112E+35
S4         100     2,7112E+35
S4         101     2,7114E+35
S4         102     2,7114E+35
S4         103     2,7114E+35
S4         104     2,7116E+35
S4         105     2,7116E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         106     2,7116E+35
S4         107     2,7617E+35
S4         108     2,7617E+35
S4         109     2,7617E+35
S4         110     2,7619E+35
S4         111     2,7619E+35
S4         112     2,7619E+35
S4         113     2,7621E+35
S4         114     2,7621E+35
S4         115     2,7623E+35
S4         116     2,7623E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         117     2,7623E+35
S4         118     2,7625E+35
S4         119     2,7625E+35
S4         120     2,7625E+35
S4         121     2,7627E+35
S4         122     2,7627E+35
S4         123     2,7627E+35
S4         124     2,7629E+35
S4         125     2,7629E+35
S4         126     2,7629E+35
S4         127     2,7631E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         128     2,7631E+35
S4         129     2,7631E+35
S4         130     2,7633E+35
S4         131     2,7633E+35
S4         132     2,7635E+35
S4         133     2,7635E+35
S4         134     2,7635E+35
S4         135     2,8136E+35
S4         136     2,8136E+35
S4         137     2,8136E+35
S4         138     2,8138E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         139     2,8138E+35
S4         140     2,8138E+35
S4         141     2,8140E+35
S4         142     2,8140E+35
S4         143     2,8142E+35
S4         144     2,8142E+35
S4         145     2,8142E+35
S4         146     2,8142E+35
S4         147     2,8144E+35
S4         148     2,8144E+35
S4         149     2,8144E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         150     2,8146E+35
S4         151     2,8146E+35
S4         152     2,8146E+35
S4         153     2,8148E+35
S4         154     2,8148E+35
S4         155     2,8148E+35
S4         156     2,8150E+35
S4         157     2,8150E+35
S4         158     2,8150E+35
S4         159     2,8152E+35
S4         160     2,8152E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         161     2,8154E+35
S4         162     2,8154E+35
S4         163     2,8154E+35
S4         164     2,8655E+35
S4         165     2,8655E+35
S4         166     2,8655E+35
S4         167     2,8655E+35
S4         168     2,8657E+35
S4         169     2,8657E+35
S4         170     2,8657E+35
S4         171     2,8659E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         172     2,8659E+35
S4         173     2,8659E+35
S4         174     2,8661E+35
S4         175     2,8661E+35
S4         176     2,8662E+35
S4         177     2,8664E+35
S4         178     2,8664E+35
S4         179     2,8666E+35
S4         180     2,8666E+35
S4         181     2,8666E+35
S4         182     2,8668E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         183     2,8668E+35
S4         184     2,8668E+35
S4         185     2,8670E+35
S4         186     2,8670E+35
S4         187     2,8670E+35
S4         188     2,8672E+35
S4         189     2,8672E+35
S4         190     2,8672E+35
S4         191     2,8674E+35
S4         192     2,8674E+35
S4         193     2,8674E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         194     2,9175E+35
S4         195     2,9175E+35
S4         196     2,9177E+35
S4         197     2,9177E+35
S4         198     2,9177E+35
S4         199     2,9179E+35
S4         200     2,9179E+35
S4         201     2,9179E+35
S4         202     2,9181E+35
S4         203     2,9181E+35
S4         204     2,9183E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         205     2,9183E+35
S4         206     2,9183E+35
S4         207     2,9185E+35
S4         208     2,9185E+35
S4         209     2,9185E+35
S4         210     2,9187E+35
S4         211     2,9187E+35
S4         212     2,9187E+35
S4         213     2,9189E+35
S4         214     2,9189E+35
S4         215     2,9189E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         216     2,9191E+35
S4         217     2,9191E+35
S4         218     2,9191E+35
S4         219     2,9193E+35
S4         220     2,9193E+35
S4         221     2,9193E+35
S4         222     2,9694E+35
S4         223     2,9694E+35
S4         224     2,9696E+35
S4         225     2,9696E+35
S4         226     2,9696E+35

COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE
---------- --------------- --------------
S4         227     2,9698E+35
S4         228     2,9698E+35
S4         229     2,9698E+35
S4         230     2,9700E+35
S4         231     2,9700E+35
S4         232     2,9700E+35
S4         233     2,9702E+35
S4         234     2,9702E+35
S4         235     2,9702E+35

251 ZEILEN AUSGEWAHLT.

 

 

©Adar-Consult, Ihr Partner für Oracle Schulungen, Seminare, Workshops und Consulting

Oracle Training und Schulungen
Tag Cloud
oracle-architekturposter import kleine excel sql-tuning packages oracle-check, sql-commander rac-praxisworkshop schulungsangebot recovery google404, sql-grundlagen sql-pl/sql-bootcamp hochverfügbarkeits-bootcamp plan, cluster oracle export application pl/sql-entwicklung pl/sql google oracle-datenbankadministration poster
AC-Blog