Re: Determine Size of Control File on RAC System

Giganews Newsgroups
Subject: Re: Determine Size of Control File on RAC System
Posted by:  Alexey Sergeyev (saefid…@devexperts.com)
Date: Fri, 28 Oct 2005

Alter database backup controlfile to '...any_filename_on_
filesystem_where_oracle_can_write...';

The size of that file will give you the size of your current controlfile;

Alexey Sergeyev

<melliott…@yahoo.com> wrote in message
news:1130499923.156353.294…@g49g2000cwa.googlegroups.com...
> 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

Replies

In response to

Determine Size of Control File on RAC System posted by melliott…@yahoo.com on 28 Oct 2005