Re: How to get the size of raw device files

hello
the size of your datafile for oracle can be computed : size of raw device (unix size via lvdisplay with hpux ) minus 1dbblocksize example:
create tablespace toto
datafile 'your raw device pathname' size xxxxxxx

then
the size of your raw device under unix yyyyyy yyyyyy=xxxxxxx+1*(dbblocksize)
all the values are in bytes.

i use this calcul with hpux,aix and solaris with noproblem try
good luck

<maiklb_at_my-deja.com> a écrit dans le message news: 8tm25d$9fv$1_at_nnrp1.deja.com...
>
>
> Is there a way to get the exact file size of a
> character special file in a Oracle Database ?
>
> 1) I can't query the information from Oracle because
> Oracle isn't running.
>
> 2) The processing of "dd if=.. of=.. bs=.." takes too long
> using small blocksizes.
>
> Thanks
> Michael
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 31 2000 - 21:43:26 CST