RE: Doubt related to ROWID
- From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- To: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>, <John.Hallas@xxxxxxxxxxxxxxxxxx>, <JSweetser@xxxxxxxx>, <ecandrietta@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Jul 2013 10:01:26 -0500
The best LIO there is! Other than not doing one at all.... :-)
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan@xxxxxxxxxxxxxxxxxx]
Sent: Wednesday, July 24, 2013 10:57 AM
To: Ric Van Dyke; John.Hallas@xxxxxxxxxxxxxxxxxx; JSweetser@xxxxxxxx;
ecandrietta@xxxxxxxxx; 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@xxxxxxxxxx>
To: <jonathan@xxxxxxxxxxxxxxxxxx>; <John.Hallas@xxxxxxxxxxxxxxxxxx>;
<JSweetser@xxxxxxxx>; <ecandrietta@xxxxxxxxx>; "ORACLE-L"
<oracle-l@xxxxxxxxxxxxx>
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
