Re: SAN storage data optimization and rowid

From: HansF <News.Hans_at_telus.net>
Date: Sat, 15 Oct 2005 12:45:08 GMT
Message-Id: <pan.2005.10.15.12.43.50.75113@telus.net>

On Wed, 12 Oct 2005 12:22:45 -0700, Ranko.Mosic_at_gmail.com interested us by writing:

> 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.

Your SAN moves files. The ROWID is effectively a pointer to (file + block + row [+ segment]). You can consider 'file' and 'block' to be logical constructs that are translated by OS and SAN to physical locations on disk at run time. Oracle does not care where your file or block is placed.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Sat Oct 15 2005 - 07:45:08 CDT