Re: Doubt related to ROWID

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 24 Jul 2013 15:56:48 +0100
Message-ID: <CBFBD76BAAAE45429D89D0B0BF68D08D_at_Primary>

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-l

Received on Wed Jul 24 2013 - 16:56:48 CEST