Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How does oracle utilize raw disk device as datafile?
Gary YU wrote:
> Hi all,
>
> I always use plain files(on HPUX) as oracle datafiles. But to my
> knowledge, raw disk device may have a better I/O performance vs.
> plain files based on OS.
>
> My question is, how do I utilize raw device when creating datafiles? I
> can create a logical volume on HPUX with the property of 'raw device',
> shall I specify the character device file of this logical volume as
> the full path of the datafile ? e.g
>
> ALTER TABLE USERS ADD DATAFILE '/dev/vg01/rlovldata1' SIZE 1000M
>
> thanks,
> Gary
Hi Gary,
Best regards
Marcin Kwasninki
Received on Thu Nov 21 2002 - 02:31:15 CST