Database Tuning (MOSC)

MOSC Banner

Parallel Execution and Execution of simple statements

edited Aug 31, 2010 2:38AM in Database Tuning (MOSC) 9 commentsAnswered
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"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center