OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Control File Size?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Control File Size? [message #63719]

Mon, 01 November 2004 19:12

IA
Messages: 91
Registered: March 2004

Member

Hi Everyone,

�

I want to find out the size of the database control file without looking into the file system.

�

Is there a dictionary view that details the size of the controlfile?

�

Thanks ... IA

�

Report message to a moderator

Re: Control File Size? [message #63794 is a reply to message #63719]

Mon, 08 November 2004 04:14

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

Unfortunately not. The V$CONTROLFILE view doesn't show file size. Initially I thought one can calculate it from V$CONTROLFILE_RECORD_SECTION, but that didn't work either:

SQL> SELECT SUM(record_size * records_total) AS cfsize
  2    FROM v$controlfile_record_section;

    CFSIZE
----------
   1721820

SQL> ! ls -l /app/oracle/oradata/orcl/control01.ctl
-rw-r-----   1 oracle   dba      3883008 Nov  8 16:19 /app/oracle/oradata/orcl
ontrol01.ctl

Best regards.

Frank

Report message to a moderator

Previous Topic:	ORA-27101
Next Topic:	whether macfee antivirus effects oracle /forms installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 06:27:08 CDT 2024