| Have difficulty in reading tkprof result.Please help. [message #51634] |
Tue, 04 June 2002 04:22  |
chao_ping
Messages: 2
Registered: June 2002
|
Junior Member |
|
|
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.
And another strange thing:
It is just during a about 5-minute's trace.It seems it is impossible that it really ran this query for that 20k times!
Some possible reason?
Thanks.
__________________
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
