You can see the control file size easily by looking at the operating sytem.
To know the location of the control files by issuing command: select * from v$controlfile or control_files parameter in the initialization paramter file.
Hope this helps.
I thought the same ... till now
Originally posted by jmodic
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.
The whole difference between a little boy and an adult man is the price of toys
Yep, I stand corrected.
The formula in the above script realy works for 8i. It gives an incorrect result for 9i though- perhaps the formula needs minor corrections to be used 9i. I think Steve Adams would be the right address to come up with a formula that works with 9i too.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Alternatively, check the length of the file using Java:
PS. Not sure if this will attempt to lock the file and crash your instance
Click Here to Expand Forum to Full Width