Re: Way to much log switching!!!
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 1 Jul 2004 11:38:10 -0700
>
> You don't need logminer to find the redo culprit, just this SQL:
>
> select module, osuser, sql_hash_value, value / (sysdate - logon_time)
redo
> from v$session s, v$sesstat ss, v$statname sn
> where s.sid = ss.sid
> and ss.statistic# = sn.statistic#
> and name = 'redo size'
> order by redo;
>
As of 9.2.0.5, the size of 'value' appears to be insufficient.
See SQL_HASH_VALUE 3746554268
MODULE OSUSER SQL_HASH_VALUE
REDO
------------------------------------------------
------------------------------ -------------- ----------------
SQL*Plus jkstill 1919576213
52,525,097
SAPLMG04 SAPServicePRD 0
54,515,452
SAPLCK2U SAPServicePRD 0
60,767,645
RSTXCONV SAPServicePRD 0
61,629,371
SAPLCOBH SAPServicePRD 0
80,551,759
SAPLSBDC SAPServicePRD 0
83,231,906
RLLL04SE SAPServicePRD 0
102,811,091
RLLS2600 SAPServicePRD 1134036037
127,774,256
RLLL05SE SAPServicePRD 0
132,841,314
SAPLSDF4 SAPServicePRD 0
143,326,763
SAPLMG46 SAPServicePRD 3518923450
159,347,584
SAPLCRK1 SAPServicePRD 0
159,850,349
SAPF110V SAPServicePRD 0
251,315,595
SYSTEM 3746554268
621,042,062,950
88 rows selected.
11:28:31 SAPPRD2 - jkstill@prd SQL> l
SYSTEM 0 282467408 20,646,438
SYSTEM 3746554268 -1.280E+09 -296,416,999,670
SYSTEM 0 0 0
SYSTEM 0 0 0
SYSTEM 4115672663 70340844 5,141,440
SYSTEM 2618850598 0 0
SYSTEM 0 0 0
SYSTEM 0 0 0
SYSTEM 0 0
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
