log file free and used space !
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: log file free and used space !

  1. #1
    Join Date
    Dec 2000
    Posts
    32

    Arrow

    How to determine the free and used space for log files ? size of the log can be dtermined by sum(bytes) from v$log.Does it help to determine to find out other two values ?

    Thanks.

    ---Radha

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    There isn't a way to determine the amount of space used and/or amount of free space of a current redo log file.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    err sum(byes) of v$log tells you the size of all log file together which is not telling the free or used size

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