Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> performance issue using select by rowid
Here is an individual statement from a larger tkprof when monitoring a
client app.
This particular statement is a select by rowid (we look up the rowid just before this statement with a primary key)
This database has too little buffer cache (I do realise that!) - but even so how can these numbers (for Query) be right?
Or to put it another way how would you go about contriving such a set of numbers?
SELECT *
FROM
MYTABLE WHERE ROWID = :b1
call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ------
Parse 5 0.00 0.00 0 0 0 0 Execute 35 0.00 0.00 0 0 0 0 Fetch 35 0.27 0.27 4110 4261 48 29 ------- ------ -------- ---------- --------- ---------- ------- total 75 0.27 0.27 4110 4261 48 29
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 186 () (recursive depth: 1)
Rows Execution Plan
------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS GOAL: ANALYZED (BY USER ROWID) OF 'MYTABLE'Received on Wed Mar 24 2004 - 05:57:13 CST