Re: SAN storage data optimization and rowid

On 12 Oct 2005 12:22:45 -0700, "Ranko.Mosic_at_gmail.com" <Ranko.Mosic_at_gmail.com> wrote:

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

This should be transparent to the end-user, so he doesn't need to bother.
Apart from that: rowids are a number within a file, and they aren't stored except for indexes.

--
Sybrand Bakker, Senior Oracle DBA