Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle 10g Rowid Question
Deepak,
This is a classic case of an older feature evolving into a current myth. The format of ROWID changed between V7 and V8, so any V7 database upgraded *in-place* would encounter a slight delay when the rows are accessed for the first time after the upgrade. [I don't remembet the specifics, but I do remember this caveat, and am willing to be corrected!] So get whoever raised that object to (re)read the new Concepts manual in Oracle Database 10g!
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)
Co-Author: Oracle Database 10g Insider Solutions http://www.samspublishing.com/title/0672327910
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Deepak Sharma
Sent: Friday, September 09, 2005 9:41 AM
To: Ric Van Dyke; oracle-l_at_freelists.org
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.
> If you are asking "has the rowid format changed in 10g?" then the
> answer is no.
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 09 2005 - 12:16:15 CDT