Tuesday 2 October 2018

Query to find the session creating more redo

How to find the session generating more number of Redo or we can say Archivelogs as well.
Using the view v$sess_io, we can find out the sessions which are performing the block_changes in database. From this we can determine the sessions.

Below is the query we can use to find the Session IDs

set pages 1000 lines 1000
SELECT s.sid, s.serial#, s.username, s.program,
i.block_changes
FROM v$session s, v$sess_io i
WHERE s.sid = i.sid
ORDER BY 5 desc;


3 comments:

  1. Hello Nikhil You made your blog in a wonderful way. This is very helpful to a fresh start in DBA Carrier.I want to bring in your notice there is something wrong while trying to access pdf download of ASM or 30+ dataguard. Please check n correct it.

    ReplyDelete
    Replies
    1. Hi Vikas,

      The site where the files were hosted is currently down and not in service these days.

      Please drop your mail id, Will forwards the documents

      Thanks and Regards,
      Nikhil

      Delete
    2. dbavikas151@gmail.com

      Thanks and Regards,
      Vikas

      Delete