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
Printable View
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
There isn't a way to determine the amount of space used and/or amount of free space of a current redo log file.
err sum(byes) of v$log tells you the size of all log file together which is not telling the free or used size