Originally posted by abhaysk
V$Controlfile_Record_Section, will give you actual size used in the allocted space by OS. So, with OS perspective this is not the size as the allocated size > the sum of the (sizes*used)
Abhay,
FRom your previous post
RECORDS_TOTAL NUMBER Number of records allocated for the section
I was using the no of records allocated and record size. But it always comes lesser that the actual cf size.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"