Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: more consistent gets, but more quickly?
Repeat the tests, but take a snapshot of v$sesstat for the session on each test. I would guess that you will find that there is a more than balancing difference in the statistic "buffer is pinned count" which also records accesses to buffered block, but uses a different buffer access mechanism.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )
____UK_______March
____USA_(FL)_May
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____USA_(CA, TX)_August
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: 27 January 2003 15:56
> As you see, the first sql generated 43629 consistent gets and the
second sql 22083 consistent gets, this is ok, how ever, the first
take 1.63 second and the second take 1.70 second.This seems strange,
right? Since in most case, higher consistent gets means longer time.
There is no one else running on this server, And I also tested with
event 10046 with no wait event.I tested for several times, with the
same result.
> Can someone help me understand it?
> Thanks very much.
>
>
>
>
>Regards
>zhu chao
>msn:chao_ping_at_163.com
>www.cnoug.org(China Oracle User Group)
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: jonathan_at_jlcomp.demon.co.uk Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Jan 27 2003 - 10:49:01 CST
![]() |
![]() |