session wait fun
From: John D Parker <orclwzrd_at_yahoo.com>
Date: Tue, 7 Jan 2014 09:54:06 -0800 (PST)
Message-ID: <1389117246.96945.YahooMailNeo_at_web163104.mail.bf1.yahoo.com>
On 11.2.0.3 on linux, I'm getting session waits of 16070 days. This equates to 44 years in my math. This smells like the old overflow issue that I remember from days of old. My google fu is not working to find anything related to excessive, impossible, unreasonable, overflow session wait times. Anyone have some info? or a bug number? This is making me crazy. The other thing is that it seems to be some how related to slow redo log performance in the log writer. But I'm seeing non idle sql net message for client waits and other events at 16000+ days of wait, doesn't matter which column in v$session I look at that math comes back the same. truly bizarre.
Date: Tue, 7 Jan 2014 09:54:06 -0800 (PST)
Message-ID: <1389117246.96945.YahooMailNeo_at_web163104.mail.bf1.yahoo.com>
On 11.2.0.3 on linux, I'm getting session waits of 16070 days. This equates to 44 years in my math. This smells like the old overflow issue that I remember from days of old. My google fu is not working to find anything related to excessive, impossible, unreasonable, overflow session wait times. Anyone have some info? or a bug number? This is making me crazy. The other thing is that it seems to be some how related to slow redo log performance in the log writer. But I'm seeing non idle sql net message for client waits and other events at 16000+ days of wait, doesn't matter which column in v$session I look at that math comes back the same. truly bizarre.
Frustrated,
john
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 07 2014 - 18:54:06 CET