-
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
-
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
Ales 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.
Jurij Modic
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:
http://www.oracle-base.com/Articles/...gFromPLSQL.asp
Cheers
PS. Not sure if this will attempt to lock the file and crash your instance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|