RE: Doubt related to ROWID
Date: Wed, 24 Jul 2013 10:01:26 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF02137A1F_at_WIN02.hotsos.com>
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.
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_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 3:48 PM Subject: RE: Doubt related to ROWID
They can rock, with a hash cluster you can get a row back with only one LIO, as far as I know it's the only way to get a single row with a single LIO.
Ric Van Dyke
Education Director
Hotsos Enterprises LTD.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 24 2013 - 17:01:26 CEST