Re: Is it possible to trace what locks my session obtains?

On Sun, Jul 17, 2016 at 9:01 AM, Michael Cunningham < napacunningham_at_gmail.com> wrote:

> Thanks Jared, I have often wondered how to find which traces I can run
> (aside form the docs). Great info.
> Also, very cool troubleshooting finding that SqlNet/Network issue.
>

You're welcome Michael, it was my pleasure.

That SQL*Net issue went on for several months, even after providing the trace files.
This is the second SR in my Oracle career that was solved by a developer at Oracle actually looking at the SR and providing a solution. The first time it happened the developer actually called me on the phone. :)

Keep in mind that some of these trace events may require a little extra effort and experimentation to use.

The SQLNet one for example does not work just by itself.

It is necessary to first start at 10046 trace, and then start the sqlnet trace via oradebug from another session. Took a few attempts to figure that out, but it was worth it.

That trace event dumps all of a sessions sqlnet packets to the trace file.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant 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