Which View display the control file /redo log file size ?

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.


Thanks
Babu

Quote:

---

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.

---

I thought the same ... till now :)

http://www.ixora.com.au/scripts/sql/...lfile_size.sql

Quote:

---

Originally posted by ales
I thought the same ... till now :)

http://www.ixora.com.au/scripts/sql/...lfile_size.sql

---

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.

Alternatively, check the length of the file using Java:

http://www.oracle-base.com/Articles/...gFromPLSQL.asp

Cheers

PS. Not sure if this will attempt to lock the file and crash your instance :)