Re: session wait fun

From: Jared Still <jkstill_at_gmail.com>
Date: Sat, 18 Jan 2014 16:51:52 -0800
Message-ID: <CAORjz=PATfz0p-dM7EOJ7vbj6Uqtr_mRo+NzuGe3UZ+1=cqT+w_at_mail.gmail.com>

Just wondering if you had an opportunity to trace a session.

It would be interesting to find know what the problem turned out to be.

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

On Fri, Jan 10, 2014 at 6:16 AM, Jared Still <jkstill_at_gmail.com> wrote:

> strace -o <tracefile_name> -f -T -ttt -p <PID>
>
> -T shows time spent in system call
> -ttt shows current time as epoch.microseconds
>
> Running the strace for 15 seconds or so should be sufficient.
>
>
>
> 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
>
>
> On Thu, Jan 9, 2014 at 8:43 PM, John D Parker <orclwzrd_at_yahoo.com> wrote:
>
>> 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-l

Received on Sun Jan 19 2014 - 01:51:52 CET