Re: session wait fun
- From: Jared Still <jkstill@xxxxxxxxx>
- To: John D Parker <orclwzrd@xxxxxxxxx>
- Date: Thu, 9 Jan 2014 19:22:24 -0800
On Tue, Jan 7, 2014 at 9:54 AM, John D Parker <orclwzrd@xxxxxxxxx> 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
Other related posts:
