| Archive log destination is generating more redo [message #619757] |
Thu, 24 July 2014 19:51  |
Database admin
Messages: 365
Registered: September 2006
Location: india
|
Senior Member |
 
|
|
Hi,
I found archive destination /arch is 90% used.
I ran below query to know which sessions currently generate redo.
SQL> select value/((sysdate-logon_time) * 1440) redo_per_minute,s.sid,serial#,logon_time,value,ss.statistic#
from v$statname sn,
v$sesstat ss,
v$session s
where s.sid = ss.sid
and sn.statistic# = ss.statistic#
and name = 'redo size'
and value>0 2 3 4 5 6 7 8
9 /
REDO_PER_MINUTE SID SERIAL# LOGON_TIM VALUE STATISTIC#
--------------- ---------- ---------- --------- ---------- ----------
.166043623 9 1 06-JUN-14 11664 178
.137250406 14 16861 12-JUL-14 2424 178
2773.0988 571 1 06-JUN-14 194801640 178
3.7447453 573 13 06-JUN-14 263056 178
16.4247786 576 4291 09-JUL-14 370664 178
.135435707 579 50737 12-JUL-14 2392 178
1035.50669 1139 1 06-JUN-14 72741152 178
16.364438 1705 2977 09-JUL-14 369296 178
55.407528 1709 1 06-JUN-14 3892208 178
9 rows selected.
How to find which session is generating more redo from the above output ?
Regards,
Srini
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
