Re: session wait fun

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 10 Jan 2014 06:16:36 -0800
Message-ID: <CAORjz=PKkdnQ_GovUXKhLo0OoFW3q0Bwks9Q2FyUSCcw6nQcJg_at_mail.gmail.com>

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 Fri Jan 10 2014 - 15:16:36 CET