RE: Oracle 10g Rowid Question
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <sharmakdeep_oracle@xxxxxxxxx>, "'Ric Van Dyke'" <Ric.Van.Dyke@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 10 Sep 2005 14:49:33 +0200
there is a new ROWID format, for bigfile tablespaces -- but since that's a new
10g feature, that cannot be the reason for delays during a conversion of an
existing database ...
apart from that, all data block do have slightly different block format bytes --
but that's only one update per block, not per row.
then, if you have bitmap indexes, there are some improvements implemented in
those structures -- but as far as I remeber correctly, Oracle does the needed
updates in a "lazy" manner. to be more precise, "lazy" is not a good term; you
have to manually rebuild them yourself to benefit from less DML overhead. newly
created bitmap indexes automatically use the new structure.
and of course I am overlooking some other reasons why things are slower the
first time you access migrated data -- you can safely assume that they are for
good reasons :-)
kind regards,
Lex.
------------------------------------------------------------------
Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Deepak Sharma
Sent: Friday, September 09, 2005 18:41
To: Ric Van Dyke; oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle 10g Rowid Question
Thanks.
One of the concerns someone raised is "All old rows in database will have
slowness the first time they are read or updated due to conversion to 10g.". I
am trying to find out if this indeed is true, and one of the things came to mind
was if rowid format changed, which doesn't seem to be the case.
- Deepak
--- Ric Van Dyke <Ric.Van.Dyke@xxxxxxxxxx> wrote:
> If you are asking "has the rowid format changed in 10g?" then the
> answer is no.
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD
Other related posts:
