Hi All,
Is there a way to know the current archive log file size using some V$ view?
Thanks and Regards
Printable View
Hi All,
Is there a way to know the current archive log file size using some V$ view?
Thanks and Regards
The row in V$ARCHIVED_LOG with max SEQUENCE# would appear to give the size in blocks of the last Archive Log written.
When I look the V$ARCHIVED_LOG view I’m looking all archive log that was archived, right? I need to know the archive log file size before creating it, maybe I’m looking for the current redo log file size before the redo log be archived…
Thanks and Regards