Have difficulty in understanding the tkprof result

From: chao_ping <chao_ping_at_163.com>
Date: 4 Jun 2002 09:08:14 GMT
Message-ID: <3cfc837e$1@usenetgateway.com>

hi, dbas: From top result i noticed that there is an oracle server process consuming much cpu, so i traced it and tkprofed it and i got the following result: select user_account into :b0 from UserPrivateInfo where user_id=:b1

call count cpu elapsed disk query current rows ------- ------ --------
---------- ---------- ---------- ---------- ---------- Parse 5 0.02 0.00
0 0 0 0 Execute 30964 2.76 2.44 0 0 0 0 Fetch 30964 3.49 2.64 0 123865 0 30964 ------- ------ -------- ---------- ---------- ----------
---------- ---------- total 61933 6.27 5.08 0 123865 0 30964

Misses in library cache during parse: 1 Optimizer goal: FIRST_ROWS Parsing user id: 32

Rows Row Source Operation -------
--------------------------------------------------- 1 TABLE ACCESS BY
INDEX ROWID USERPRIVATEINFO 2 INDEX UNIQUE SCAN (object id 6593) as you see, this is just a select statement, there should not be any execute cpu, how now there is so much, as you see. Can someone help me on this issue? thanks.

--

Posted via dBforums
http://dbforums.com Received on Tue Jun 04 2002 - 04:08:14 CDT