DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

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

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Which View display the control file size ?
    Which View display the redolog file size ?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    v$controlfile, v$log

    I'm not sure if you can get the size of the controlfile?

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Aug 2002
    Posts
    21
    U can see it thru contolfile_record_section too i think

  4. #4
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    No size information .

    In Oracle7.3 , there is no v$contolfile_record_section
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  5. #5
    Join Date
    Aug 2002
    Posts
    21
    What does record_size show u in V$controlfile_record_section

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

  7. #7
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    Jmodic u are right
    I don't think there is any need to know the sizes of files like controlfiles or initialisation files .
    siva prakash
    DBA

  8. #8
    Join Date
    Aug 2002
    Posts
    21
    select sum(record_size) from v$controlfile_record_section will give u the app size of control file

  9. #9
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Originally posted by sm8728
    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.
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  10. #10
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Just use:

    $ ls -la

    and u can see size control files and log files.

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