Re: Determine Size of Control File on RAC System

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 29 Oct 2005 02:59:38 GMT
Message-Id: <pan.2005.10.29.02.59.37.190770@sbcglobal.net>

On Fri, 28 Oct 2005 16:45:51 +0400, Alexey Sergeyev wrote:

> 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
>

Actually, if you are using RMAN, you don't have to do that. There is a table called V$BACKUP_CONTROLFILE_SUMMARY which contains the column "INPUT_BYTES". Voila. That, unfortunately, also works only on 10g.

-- 
http://www.mgogala.com

Received on Fri Oct 28 2005 - 21:59:38 CDT