Re: Way to much log switching!!!

From: <Jared.Still_at_radisys.com>
Date: Thu, 1 Jul 2004 11:38:10 -0700
Message-ID: <OF3CF03CB2.5C044562-ON88256EC4.0065AFB8-88256EC4.00665A7A@radisys.com>

>
> 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_at_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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 01 2004 - 13:35:22 CDT