Dear Friends,
You can use this script to find the controlfile size,
set termout off
column value new_value BlkSz
select
value
from
sys.v_$parameter
where
name = 'db_block_size'
/
set termout on
set verify off
select
&BlkSz * (1 + 2 * sum(ceil(record_size * records_total / (&BlkSz - 24)))) "controlfile size"
from
sys.v_$controlfile_record_section
OutPut will look like this,
VALUE
----------------------
8192
1 row selected.
controlfile size
----------------
7806976
1 row selected.
This script returns blocksize also.
Bye,
UpeshP