Database Reference
In-Depth Information
------- XXXX, Version 11.2.0.2.0 : 25.04.2012 11:37:33 ---------
---- DISK_READS=0, DISK_READS_PER_EX=0, BUFFER_GETS=263, BUFFER_GETS_PER_EX=263
---- 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.0600/0.0642, per ex.=0.0600/0.0642
---- 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 = 567822290003159453, Force Signature = 567822290003159453
---- Service : SYS$USERS
---- Module : sqlplus.exe
---- USER="XXX", SCHEMA="XXXX", OPTIMIZER_MODE=ALL_ROWS, OPTIMIZER_ENV_HASH_VALUE=2329734407,
USERS_OPEN=0, USERS_EXEC=0
---- SQL_ID=>1sayr8p8sjpt8<, ADDRESS=>00000003E47DE868<, HASH_VALUE=>1367922472<,
OLD_HASH_VALUE=>191730696<, CHILD_NUMBER=>4<
SELECT /* 1000 */
ABRUF.AbrufId, ABRUF.Typ, ABRUF.AbrufNr, ABRUF.ZeilNr, ABRUF.ArtId_ArtNr, ABRUF.ArtId_MandId,
...
---- Execution Plan (Plan Hash Value : 1480903551) :
0 SELECT STATEMENT Optimizer=HINT: ALL_ROWS (Cost=25)
1 0 SORT (ORDER BY) (Bind Peeking used) (Cost=25 Card=29 Bytes=32364
CPU_Cost=7080330 IO_Cost=23 Time=1) (Runtime Stats - starts:1, ela:0.01, dr:0, dwr:0, bg:263,
rows:31) (WA Stats - Policy:AUTO, Last Mem(K):46, Opt Mem(K):51, 1 Pass Mem(K):51,
Opt/1/Mult:1/0/0)
2 1 NESTED LOOPS (Runtime Stats - starts:1, ela:0.01, dr:0, dwr:0, bg:263,
rows:31)
3 2 NESTED LOOPS (Cost=24 Card=29 Bytes=32364 CPU_Cost=3773126 IO_Cost=23
Time=1) (Runtime Stats - starts:1, ela:0.01, dr:0, dwr:0, bg:232, rows:31)
4 3 NESTED LOOPS (Cost=19 Card=29 Bytes=10759 CPU_Cost=3705026 IO_Cost=17
Time=1) (Runtime Stats - starts:1, ela:0.01, dr:0, dwr:0, bg:188, rows:31)
5 4 NESTED LOOPS (Cost=13 Card=29 Bytes=9338 CPU_Cost=3656298 IO_Cost=12
Time=1) (Runtime Stats - starts:1, ela:0.01, dr:0, dwr:0, bg:96, rows:31)
6 5 VIEW OF VW_NSO_1 (Cost=3 Card=2 Bytes=22 CPU_Cost=26010 IO_Cost=3
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):518, 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=3 Card=2 Bytes=118 CPU_Cost=26010 IO_Cost=3
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=1 Card=2 Bytes=60
CPU_Cost=4353 IO_Cost=1 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=2304 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=1 Card=1 Bytes=29
CPU_Cost=10828 IO_Cost=1 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:86, rows:31)
14 6 TABLE ACCESS (BY INDEX ROWID) OF ABRUF (Cost=5 Card=14 Bytes=4354
CPU_Cost=164671 IO_Cost=5 Time=1) (Runtime Stats - starts:2, ela:0.00, dr:0, dwr:0, bg:86,
rows:31)
15 7 INDEX (RANGE SCAN) OF IDX_ABRUF_STATUS_LIDAT_ALL (Cost=4 Card=3
CPU_Cost=162134 IO_Cost=4 Time=1) (Runtime Stats - starts:2, ela:0.00, dr:0, dwr:0, bg:80,
rows:31)
16 4 TABLE ACCESS (BY INDEX ROWID) OF ARTB (Cost=1 Card=1 Bytes=49
CPU_Cost=1680 IO_Cost=1 Time=1) (Runtime Stats - starts:31, ela:0.00, dr:0, dwr:0, bg:92,
rows:31)
17 5 INDEX (UNIQUE SCAN) OF PK_ARTB (Cost=1 Card=1 CPU_Cost=210 IO_Cost=1
Time=1) (Runtime Stats - starts:31, ela:0.00, dr:0, dwr:0, bg:61, rows:31)
18 3 INDEX (UNIQUE SCAN) OF PK_POSTEN (Cost=1 Card=1 CPU_Cost=210 IO_Cost=1
Time=1) (Runtime Stats - starts:31, ela:0.00, dr:0, dwr:0, bg:44, rows:31)
19 2 TABLE ACCESS (BY INDEX ROWID) OF POSTEN (Cost=1 Card=1 Bytes=745
CPU_Cost=2348 IO_Cost=1 Time=1) (Runtime Stats - starts:31, ela:0.00, dr:0, dwr:0, bg:31,
rows:31)
