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 -> Tkprof values current and query

Tkprof values current and query

From: Jantah <jantah_at_hot.mail.com>
Date: Wed, 18 Oct 2000 07:56:41 +0200
Message-ID: <pqequskn94m24l921tfkjqdkbkttea2t7r@4ax.com>

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 Wed Oct 18 2000 - 00:56:41 CDT

Original text of this message

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