Q
Problem solve Get help with specific problems with your technologies, process and projects.

Finding number of redo logs generated in a session

Where do I look to find the number of redo logs generated in a specific session?

Where do I look to find the number of redo logs generated in a specific session?
Redo logs are not session-specific, therefore you cannot find the information you seek. Redo logs store the information to replay, or redo, all transactions that occurred on the database, regardless of session. However, you can look up the total redo size created for a session by querying V$SESSION, V$SESSTAT and V$STATNAME as follows:
SELECT se.sid,se.username,st.value AS redo_size
FROM v$session se, v$sesstat st, v$statname sn
WHERE se.sid = st.sid and st.statistic#=sn.statistic#
AND sn.name = 'redo size';

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close