Tuesday, December 5

Oracle trace event 10132

The new "in" Oracle trace event seems to be 10132, it's pretty cool. Most Oracle DBA's and developers have probably at least heard about trace levels 10046 and 10053.
10132 is a different from the classic two in the sense that it is is really easy for anyone to intepret, the 10132 trace event gives you a full execution plan and optimizer settings in the udump (user_dump_dest) directory.
It's an easy thing to throw in a script or even as a logon trigger when troubleshooting query problems. Think hibernate or other (weird) ORM tool.

Lets take a look:
SQL> alter session set events
2 '10132 trace name context forever, level 12';

Session altered.

SQL> select e.ename,d.dname from dept d, emp e where
2 d.deptno=e.deptno;

ENAME DNAME
---------- --------------
SMITH RESEARCH
...
MILLER ACCOUNTING

14 rows selected.

SQL>
And the trace we get looks like this.

5 comments:

Don said...

That's the trace without tkprof parsing?

Hampus said...

No tkprof involved, the trace file is fairly straight forward and readable in any editor.

Anonymous said...

In 10G. The 10053 trace extended to include Y10132 at the same time.

Sun Flower said...

Oracle trace events are useful for debugging the Oracle database server. The following two examples are simply to demonstrate syntax. Refer to later notes on this page for an explanation of what these particular events do sbobetaprender poker

Anonymous said...

This article is really useful I learn so much about it
Best Online Pharmacy