Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Using below query, we can easily identify which session/transaction generating more redo logs.
Query 1:
V$Sess_io & V$Session
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;
BLOCK_CHANGES column shows how much blocks have been changed the session.
Query 2:
Below query shows the amount of undo blocks & undo records accessed by the transaction.
SELECT s.sid, s.serial#, s.username, s.program,
t.used_ublk, t.used_urec
FROM v$session s, v$transaction t
WHERE s.taddr = t.addr
ORDER BY 5,6 desc;
Query 1:
V$Sess_io & V$Session
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;
BLOCK_CHANGES column shows how much blocks have been changed the session.
Query 2:
Below query shows the amount of undo blocks & undo records accessed by the transaction.
SELECT s.sid, s.serial#, s.username, s.program,
t.used_ublk, t.used_urec
FROM v$session s, v$transaction t
WHERE s.taddr = t.addr
ORDER BY 5,6 desc;
No comments:
Post a Comment