Database Reference
In-Depth Information
------- XXXX, Version 11.2.0.2.0 : 25.04.2012 10:17:41 ---------
---- DISK_READS=0, DISK_READS_PER_EX=0, BUFFER_GETS=1404, BUFFER_GETS_PER_EX=1404
---- DIRECT_WRITES=0, DIRECT_WRITES_PER_EX=0
---- PARSE_CALLS=1, EXECUTIONS=1, ROWS_PROCESSED=31
---- IS_SHAREABLE=Y, IS_BIND_SENSITIVE=Y, IS_BIND_AWARE=N
---- CPU/Elapsed Time (sec.) total=0.5500/0.5647, per ex.=0.5500/0.5647
---- PL/SQL Exec Time (sec.) total=0.0000, per ex.=0.0000
---- JAVA Exec Time (sec.) total=0.0000, per ex.=0.0000
---- Application Wait Time (sec.) total=0.0000, per ex.=0.0000
---- Concurrency Wait Time (sec.) total=0.0000, per ex.=0.0000
---- Cluster Wait Time (sec.) total=0.0000, per ex.=0.0000
---- User IO Wait Time (sec.) total=0.0000, per ex.=0.0000
---- Exact Signature = 17618769052838055190, Force Signature = 17618769052838055190
---- Service : SYS$USERS
---- Module : sqlplus.exe
---- USER="XXX", SCHEMA="XXX", OPTIMIZER_MODE=ALL_ROWS, OPTIMIZER_ENV_HASH_VALUE=2513147700,
USERS_OPEN=0, USERS_EXEC=0
---- SQL_ID=>92wn8cjrk91na<, ADDRESS=>0000000412950830<, HASH_VALUE=>1864664714<,
OLD_HASH_VALUE=>1431980524<, CHILD_NUMBER=>0<
SELECT
ABRUF.AbrufId, ABRUF.Typ, ABRUF.AbrufNr, ABRUF.ZeilNr, ABRUF.ArtId_ArtNr, ABRUF.ArtId_MandId,
ABRUF.ArtId_Pt, ABRUF.BeD, ABRUF.LiDat, ABRUF.MData, ABRUF.PanLi, ABRUF.PanDri,
ABRUF.PanDriAdr, ABRUF.Prod,
...
---- Execution Plan (Plan Hash Value : 1480903551) :
0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=117)
1 0 SORT (ORDER BY) (Bind Peeking used) (Cost=117 Card=29 Bytes=32364
CPU_Cost=8969049 IO_Cost=114 Time=1) (Runtime Stats - starts:1, ela:0.01, dr:0, dwr:0, bg:268,
rows:31) (WA Stats - Policy:AUTO, Last Mem(K):44, Opt Mem(K):49, 1 Pass Mem(K):4
9, Opt/1/Mult:1/0/0)
2 1 NESTED LOOPS (Runtime Stats - starts:1, ela:0.01, dr:0, dwr:0, bg:268,
rows:31)
3 2 NESTED LOOPS (Cost=116 Card=29 Bytes=32364 CPU_Cost=5661845 IO_Cost=114
Time=1) (Runtime Stats - starts:1, ela:0.01, dr:0, dwr:0, bg:237, rows:31)
4 3 NESTED LOOPS (Cost=87 Card=29 Bytes=10759 CPU_Cost=5321344 IO_Cost=85
Time=1) (Runtime Stats - starts:1, ela:0.01, dr:0, dwr:0, bg:190, rows:31)
5 4 NESTED LOOPS (Cost=58 Card=29 Bytes=9338 CPU_Cost=5077702 IO_Cost=56
Time=1) (Runtime Stats - starts:1, ela:0.01, dr:0, dwr:0, bg:98, rows:31)
6 5 VIEW OF VW_NSO_1 (Cost=11 Card=2 Bytes=22 CPU_Cost=130049 IO_Cost=11
Time=1) (Runtime Stats - starts:1, ela:0.00, dr:0, dwr:0, bg:10, rows:1)
7 6 HASH (UNIQUE) (Runtime Stats - starts:1, ela:0.00, dr:0, dwr:0,
bg:10, rows:1) (WA Stats - Policy:AUTO, Last Mem(K):485, Opt Mem(K):1181, 1 Pass Mem(K):1181,
Opt/1/Mult:1/0/0)
8 7 NESTED LOOPS (Runtime Stats - starts:1, ela:0.00, dr:0, dwr:0,
bg:10, rows:31)
9 8 NESTED LOOPS (Cost=11 Card=2 Bytes=118 CPU_Cost=130049
IO_Cost=11 Time=1) (Runtime Stats - starts:1, ela:0.00, dr:0, dwr:0, bg:5, rows:31)
10 9 INDEX (RANGE SCAN) OF IDX_ABRSSCC_SSCC (Cost=3 Card=2 Bytes=60
CPU_Cost=21764 IO_Cost=3 Time=1) (Runtime Stats - starts:1, ela:0.00, dr:0, dwr:0, bg:3,
rows:1)
11 9 INDEX (RANGE SCAN) OF IDX_ABRUF_ABRUFNR (Cost=1 Card=22
CPU_Cost=11521 IO_Cost=1 Time=1) (Runtime Stats - starts:1, ela:0.00, dr:0, dwr:0, bg:2,
rows:31)
12 8 TABLE ACCESS (BY INDEX ROWID) OF ABRUF (Cost=4 Card=1 Bytes=29
CPU_Cost=54142 IO_Cost=4 Time=1) (Runtime Stats - starts:31, ela:0.00, dr:0, dwr:0, bg:5,
rows:31)
13 5 INLIST ITERATOR (Runtime Stats - starts:1, ela:0.00, dr:0, dwr:0,
bg:88, rows:31)
14 6 TABLE ACCESS (BY INDEX ROWID) OF ABRUF (Cost=23 Card=14 Bytes=4354
CPU_Cost=823353 IO_Cost=23 Time=1) (Runtime Stats - starts:2, ela:0.00, dr:0, dwr:0, bg:88,
rows:31)
15 7 INDEX (RANGE SCAN) OF IDX_ABRUF_STATUS_LIDAT_ALL (Cost=22 Card=3
CPU_Cost=810672 IO_Cost=22 Time=1) (Runtime Stats - starts:2, ela:0.00, dr:0, dwr:0, bg:79,
rows:31)
