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;
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;
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.
ReplyDeleteHi Vikas,
DeleteThe 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
dbavikas151@gmail.com
DeleteThanks and Regards,
Vikas