Database Administration (MOSC)

MOSC Banner

How to estimate the size occupied by datafiles section in controlfile?

edited Apr 25, 2011 7:08PM in Database Administration (MOSC) 3 commentsAnswered ✓
 Hi,       According to oracle documentation, the max control file is 20000 database blocks. The current blocks of our controlfile size is 10056 (with 8k as block size), which reaches half of the limit.  when querying v$controlfile_record_section using the sql below, the total size is less than 1M, which is way off from the actual controfil size ~82M. Where can I find the information of actual size distribution of controlfile?How do I estimate the size occupied by datafiles section in controlfile?
select sum(RECORD_SIZE/1024/1024) from  V$CONTROLFILE_RECORD_SECTION;


Thanks&Regards
Prem



Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center