Skip to Content
Former Member
May 29, 2013 at 09:59 PM

Monitoring log segment usage


We are trying to monitor our redo log usage rate. Using the m_log_segments_reset we can see what the currently used segment is but since the segment_id is static and the log segments cycles by default we cannot tell how many logs have been used for a period of time.

In Oracle you can query v$log and the sequence# increments each time a log starts to be used. Is there an equivalent in Hana?