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:

  1. That's the trace without tkprof parsing?

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

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

    ReplyDelete
  4. 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

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

    ReplyDelete