Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> performance issue using select by rowid

performance issue using select by rowid

From: malcolm <malcolmfssmith_at_hotmail.com>
Date: 24 Mar 2004 03:57:13 -0800
Message-ID: <492439c8.0403240357.6ef0ea43@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US