Re: session wait fun
From: John D Parker <orclwzrd_at_yahoo.com>
Date: Thu, 9 Jan 2014 20:43:38 -0800 (PST)
Message-ID: <1389329018.78339.YahooMailNeo_at_web163105.mail.bf1.yahoo.com>
Date: Thu, 9 Jan 2014 20:43:38 -0800 (PST)
Message-ID: <1389329018.78339.YahooMailNeo_at_web163105.mail.bf1.yahoo.com>
ok, strace is back on the table. any suggested favorite switches. ________________________________ From: Jared Still <jkstill_at_gmail.com> To: John D Parker <orclwzrd_at_yahoo.com> Cc: oracle-l <oracle-l_at_freelists.org> Sent: Thursday, January 9, 2014 9:22 PM Subject: Re: session wait fun On Tue, Jan 7, 2014 at 9:54 AM, John D Parker <orclwzrd_at_yahoo.com> wrote: I'm getting session waits of 16070 days. It would be interesting to see an strace on one of the affected session.s Most interested in seeing the times() and gettimeofday() calls. I know you sated you do not want to strace, but if you want to find the root cause... There were a number of bugs with times() in 10.2.x that caused some weirdness. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Sr Oracle DBA at Pythian Pythian Blog http://www.pythian.com/blog/author/still/ Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 10 2014 - 05:43:38 CET