Re: Determine Size of Control File on RAC System

On Fri, 28 Oct 2005 04:45:23 -0700, melliott42 wrote:

> Hello,
>
> In Oracle 9i on Solaris, how can I determine the current size of the
> control file?
>
> I cannot look at the file itself as it is on a raw device. OEM gives
> various stats on the control file but I'm not sure which one should be
> interpreted as the physical file size.
>
> Thanks for your help,
>
> Michael42

This actually applies to any unix and to any raw device, not just control files:

dd if=/dev/rdsk/vol/device of=/dev/null bs=1048576

The dd command will actually give you the size in MB by telling you how manny blocks did it copy. If you have rood access, you can use fdisk -l command like this:
# fdisk -l /dev/hdd

Disk /dev/hdd: 120.0 GB, 120034123776 bytes 255 heads, 63 sectors/track, 14593 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/hdd1               1        1305    10482381   83  Linux
/dev/hdd2            1306        2580    10241437+  83  Linux
/dev/hdd3            2581       14593    96494422+   5  Extended
/dev/hdd5            2581        3203     5004216   83  Linux
/dev/hdd6            3204        3514     2498076    b  W95 FAT32
/dev/hdd7            3515        4096     4674883+  83  Linux
/dev/hdd8   *        4097        6587    20008926   83  Linux

Obviously, this is not Solaris, but you get the idea.

-- 
http://www.mgogala.com