RE: Doubt related to ROWID
Date: Wed, 24 Jul 2013 10:07:39 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF02137A24_at_WIN02.hotsos.com>
Roger that, what I was more joking at was to not even get the row at all. The fastest way to do anything is to not do it at all. ;-)
(My kids seem to have listen to me a bit too much on this point....)
Ric Van Dyke
Education Director
Hotsos Enterprises LTD.
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]
Sent: Wednesday, July 24, 2013 11:04 AM
To: Ric Van Dyke; ORACLE-L
Subject: Re: Doubt related to ROWID
Well,
You could avoid the LIO by using the result cache, but there are far fewer latches on the result cache, so not doing the LIO might cause more contention and therefore be more resource-intensive than doing the LIO ;)
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
- Original Message ----- From: "Ric Van Dyke" <ric.van.dyke_at_hotsos.com> To: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>; <John.Hallas_at_morrisonsplc.co.uk>; <JSweetser_at_icat.com>; <ecandrietta_at_gmail.com>; "ORACLE-L" <oracle-l_at_freelists.org> Sent: Wednesday, July 24, 2013 4:01 PM Subject: RE: Doubt related to ROWID
The best LIO there is! Other than not doing one at all.... :-)
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]
Sent: Wednesday, July 24, 2013 10:57 AM
To: Ric Van Dyke; John.Hallas_at_morrisonsplc.co.uk; JSweetser_at_icat.com;
ecandrietta_at_gmail.com; ORACLE-L
Subject: Re: Doubt related to ROWID
Slightly better even than "one LIO" - with the correct configuration
(and a bit of luck, sometimes) it can be a "consistent get -
examination", which is an LIO that requires only a single latch, and
accesses the buffer while holding the latch rather than having to go
through the whole pin cycle.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 24 2013 - 17:07:39 CEST