Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Tkprof values "query" and "current"
I am trying to reduce the amount of buffer [1] gets generated by one of my insert queries. I noticed the following behaviour in my trace file when I replaced an outer join by a MINUS operator:
I am unable to find any useful information on this last value. Is this a part of the 'query' gets, or should I add these numbers to get the total amount of gets? What is the difference exactly??
Original query:
call count cpu elapsed disk query current rows ------- ------ ---- ------- ------ ------ ------- ------
Parse 0 0.00 0.00 0 0 0 0 Execute 1 4.92 6.07 2304 124873 3 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ ---- ------- ------ ------ ------- ------ total 1 4.92 6.07 2304 124873 3 0
Modified query:
call count cpu elapsed disk query current rows ------- ------ ---- ------- ------ ------ ------- ------
Parse 0 0.00 0.00 0 0 0 0 Execute 2 4.97 7.15 4611 6149 760 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ ---- ------- ------ ------ ------- ------ total 2 4.97 7.15 4611 6149 760 0
[1] Another question: is a 'buffer' synonym to an 'Oracle block' here?
(Running Oracle 7.3.3 on Solaris)
-- Jan jantah_at_hot.mail.com ...and you know what to do with "hot.mail", right?Received on Sat Oct 14 2000 - 09:42:53 CDT