From oracle-l-bounce@freelists.org Fri Sep 9 12:16:15 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j89HGFxp011926 for ; Fri, 9 Sep 2005 12:16:15 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j89HGBIP011911 for ; Fri, 9 Sep 2005 12:16:11 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A0D871EB42C; Fri, 9 Sep 2005 12:16:04 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06692-10; Fri, 9 Sep 2005 12:16:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 269E61EB497; Fri, 9 Sep 2005 12:16:04 -0500 (EST) Message-ID: From: John Kanagaraj To: "'sharmakdeep_oracle@yahoo.com'" , oracle-l@freelists.org Subject: RE: Oracle 10g Rowid Question Date: Fri, 9 Sep 2005 10:09:45 -0700 MIME-Version: 1.0 Content-Type: text/plain X-archive-position: 25231 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: john.kanagaraj@hds.com Precedence: normal Reply-To: john.kanagaraj@hds.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.4 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 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 ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Deepak Sharma Sent: Friday, September 09, 2005 9:41 AM To: Ric Van Dyke; oracle-l@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. - Deepak --- Ric Van Dyke 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 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l