From oracle-l-bounce@freelists.org Wed Oct 12 17:11:14 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9CMBEhw026741 for ; Wed, 12 Oct 2005 17:11:14 -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 j9CMBCvX026727 for ; Wed, 12 Oct 2005 17:11:12 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0FF261FC388; Wed, 12 Oct 2005 17:11:06 -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 01249-04; Wed, 12 Oct 2005 17:11:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F2F071FC2AD; Wed, 12 Oct 2005 17:11:04 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=cDb15NODO/5+Fh7i2dUnUdNbDVUGdE08KkBE9tVqGFiSaltqGwK5jClYDTTh5hQorryjNXU2kEoGlq7hwbYgYTNw9SJBfOj+bxjHyGarhhcgldVXuZCo5MBOZpTxpJ5Y2u60NGKMRP4vNYQ4gIJJNcRTb2OuFEXL99tdw1J7kCU= Message-ID: Date: Thu, 13 Oct 2005 00:09:02 +0200 From: Alex Gorbachev To: ranko.mosic@gmail.com Subject: Re: SAN storage data movement and ROWID Cc: oracle-l In-Reply-To: <367369f10510121224p3fdb489aue8436a60479d5b21@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: <367369f10510121224p3fdb489aue8436a60479d5b21@mail.gmail.com> X-archive-position: 26872 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gorbyx@gmail.com Precedence: normal Reply-To: gorbyx@gmail.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-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-2.8 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 This is done on another layer and is trasparrent to Oracle and even to OS. Oracle and OS will see the same devices with the same content. Could only be performance degradation during massive rerganization. 2005/10/12, Ranko Mosic : > > > Hi, > We are using Hitachi SAN 9960 which has seems to have something like Dynamic > optimizer. It migrates (moves )data automatically to avoid hot spots. Can > this be enabled with Oracle running ? What happens with ROWID's if row is > moved around ? Can this work at all ? > > Regards, Ranko. -- Best regards, Alex Gorbachev -- http://www.freelists.org/webpage/oracle-l