Re: SAN storage data optimization and rowid

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Wed, 12 Oct 2005 21:57:53 +0200
Message-ID: <434d6ac4$0$24768$ba620e4c@news.skynet.be>

<Ranko.Mosic_at_gmail.com> wrote in message news:1129144965.066160.43240_at_g43g2000cwa.googlegroups.com...
> 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.
>

I dont't think this changes the ROWID's, since the SAN "disks" (actually logical devices built from several "slices" of real disks) are seen by the OS as logical devices (example hdisk) which name doesn't change.

Matthias Received on Wed Oct 12 2005 - 14:57:53 CDT