1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
|
SQL> create global temporary table gtt
(
OWNER VARCHAR2(30) not null,
OBJECT_NAME VARCHAR2(30) not null,
SUBOBJECT_NAME VARCHAR2(30),
OBJECT_ID NUMBER not null,
DATA_OBJECT_ID NUMBER,
OBJECT_TYPE VARCHAR2(19),
CREATED DATE not null,
LAST_DDL_TIME DATE not null,
TIMESTAMP VARCHAR2(19),
STATUS VARCHAR2(7),
TEMPORARY VARCHAR2(1),
GENERATED VARCHAR2(1),
SECONDARY VARCHAR2(1)
)
on commit delete rows
/
Table créée.
SQL> set autotrace traceonly statistics
SQL> insert into gtt select * from all_objects;
25870 ligne(s) créée(s).
Statistiques
----------------------------------------------------------
276 recursive calls
1816 db block gets
135410 consistent gets
1 physical reads
136084 redo size
833 bytes sent via SQL*Net to client
734 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
634 sorts (memory)
0 sorts (disk)
25870 rows processed |
Partager