Re: session wait fun

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 9 Jan 2014 19:22:24 -0800
Message-ID: <CAORjz=NDePTw9Cc5OBcr4tH+xcYA6HdRiUeBbE6zfyvvNqKszQ_at_mail.gmail.com>

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-l

Received on Fri Jan 10 2014 - 04:22:24 CET