Which View display the control file size ?
Which View display the redolog file size ?
Printable View
Which View display the control file size ?
Which View display the redolog file size ?
v$controlfile, v$log
I'm not sure if you can get the size of the controlfile?
Regards
U can see it thru contolfile_record_section too i think
No size information .
In Oracle7.3 , there is no v$contolfile_record_section
What does record_size show u in V$controlfile_record_section
There is no way you could find the size of controlfile from within the database. It is not recorded anywhere, no matter of the release you are using. Since controlfile size changes dynamicaly, what would be the point in storing that information anywhere?
Jmodic u are right
I don't think there is any need to know the sizes of files like controlfiles or initialisation files .
select sum(record_size) from v$controlfile_record_section will give u the app size of control file
I wouldn't rely on it, for example on my prod box it gives hardly a half of the real size.Quote:
Originally posted by sm8728
select sum(record_size) from v$controlfile_record_section will give u the app size of control file
Just use:
$ ls -la
and u can see size control files and log files.