RE: Doubt related to ROWID
Date: Wed, 24 Jul 2013 09:48:48 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF02137A1B_at_WIN02.hotsos.com>
Also I believe the data dictionary still uses clusters quite a bit. Maybe not as much now, but for a long time nearly the entire dictionary was stored in clusters. Mostly Index clusters as I recall.
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.
Jonathan is exactly right, since on one uses them Oracle is reluctant to put any development effort into them.
Ric Van Dyke
Education Director
Hotsos Enterprises LTD.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Lewis
Sent: Wednesday, July 24, 2013 9:36 AM
To: John.Hallas_at_morrisonsplc.co.uk; JSweetser_at_icat.com;
ecandrietta_at_gmail.com; ORACLE-L
Subject: Re: Doubt related to ROWID
Oracle Corp. in a record-breaking tpc-C benchmark.
But then, they also introduced partitioned clusters for the test - and that has the potential to make clustering MUCH more desirable in modern systems.
I think there's a catch-22 in play, though. No-one uses them, so Oracle won't improve them, but until they've been improved no-one will think about using them.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
- Original Message ----- From: "John Hallas" <John.Hallas_at_morrisonsplc.co.uk> To: <JSweetser_at_icat.com>; <ecandrietta_at_gmail.com>; "ORACLE-L" <oracle-l_at_freelists.org> Sent: Wednesday, July 24, 2013 10:13 AM Subject: RE: Doubt related to ROWID
| Does anybody still use clusters these days? |
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 24 2013 - 16:48:48 CEST