DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

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

  1. #11
    Join Date
    Feb 2001
    Posts
    27

    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

  2. #12
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    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

  3. #13
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #14
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width