Determine Size of Control File

[Michael42]

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

 

[donkeyhote]

The easy and possibly only way I can think of is at the OS level do a ls -altr / or df -k the solaris equivalent on the file

 

[Michael42]

donkeyhote,

Thanks for posting. Normally your technique would work but because I am on a clustered file system OS commands cannot determine this.

I have found a solution that I would like to share.

Alter database backup controlfile to 'filesystem_where_oracle_can_write.ctl';

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

Thanks,

Michael42