Re: Determine Size of Control File on RAC System

Giganews Newsgroups
Subject: Re: Determine Size of Control File on RAC System
Posted by:  yong3…@yahoo.com
Date: 28 Oct 2005

Alternatively,
To find controlfile size as viewed at OS level but from inside Oracle,
select cfnam, (cffsz+1)*cfbsz from x$kcccf. cfbsz is the controlfile
log block size; should report the same as the command dbfsize
controlfile ($ORACLE_HOME/bin/dbfsize is available on UNIX only)

Yong Huang

Replies

In response to

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