Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Determine Size of Control File on RAC System

Re: Determine Size of Control File on RAC System

From: <yong321_at_yahoo.com>
Date: 28 Oct 2005 09:50:56 -0700
Message-ID: <1130518256.883335.200370@g14g2000cwa.googlegroups.com> 





You're right. That column is only available in 10g. It won't work on
OP's database (9i).



dbfsize reports the size and block size of datafiles, logfiles and
controlfiles as viewed by Oracle. The size should be one block size
smaller than viewed by OS, which uses the first block for OSD layer
information. (Although the concept of block size is not commonly used
for controlfiles and logfiles, it does exist.)



Yong Huang
Received on Fri Oct 28 2005 - 11:50:56 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US