Sundaramurthy Blog

February 1, 2010

Control file size

Filed under: Inside Controle file — sundar5 @ 10:32 pm

select cfnam, (cffsz+1)*cfbsz from x$kcccf;

CFNAM                                (CFFSZ+1)*CFBSZ
—————————–                         —————
/u01/database/control01.ctl           29048832
/u02/database/control02.ctl           29048832
/u03/database/control03.ctl           29048832

SQL>!ls -l /u01/database/control01.ctl
-rw-r—–  1 oracle dba 29048832 Feb  1  2010 /u01/database/control01.ctl
SQL> !ls -l /u01/database/control01.ctl
-rw-r—–  1 oracle dba 29048832 Feb  1  2010 /u02/database/control02.ctl
SQL> !ls -l /u03/database/control03.ctl
-rw-r—–  1 oracle dba 29048832 Feb  1  2010 /u03/database/control03.ctl

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: