Parallel Execution and Execution of simple statements
Hi all!
I' ve monitored a strange behaviour when executing a simple query on a small table, e.g.
SELECT "PGSLSL", "U_VERSION", "PGSLTEXT", "TRAESL", "PGSKSL"
FROM
"SOZPGSL" WHERE "PGSLSL" = :"WPGSLSL"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.02 0.01 0 6 0 0
Fetch 3 0.00 3.31 0 0 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.02 3.32 0 6 0 3
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 12 (SOZOPPD1)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'SOZPGSL' [:Q1271563000]
SELECT /*+ NO_EXPAND ROWID(A1) */ A1."PGSLSL",A1."U_VERSION",
A1."PGSLTEXT",A1."TRAESL",A1."PGSKSL" FROM "SOZPGSL"
I' ve monitored a strange behaviour when executing a simple query on a small table, e.g.
SELECT "PGSLSL", "U_VERSION", "PGSLTEXT", "TRAESL", "PGSKSL"
FROM
"SOZPGSL" WHERE "PGSLSL" = :"WPGSLSL"
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 3 0.02 0.01 0 6 0 0
Fetch 3 0.00 3.31 0 0 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.02 3.32 0 6 0 3
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 12 (SOZOPPD1)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'SOZPGSL' [:Q1271563000]
SELECT /*+ NO_EXPAND ROWID(A1) */ A1."PGSLSL",A1."U_VERSION",
A1."PGSLTEXT",A1."TRAESL",A1."PGSKSL" FROM "SOZPGSL"
0