Sunday, May 6, 2012

SQL tracing..


Enable trace:
SQL> ALTER SESSION SET sql_trace=TRUE;

Disable trace:
SQL> ALTER SESSION SET sql_trace=FALSE;


Example: Sort by elapsed time.

tkprof trcfile txt.out sort=prsela

More information check this link..
http://www.oracle-base.com/articles/10g/SQLTrace10046TrcsessAndTkprof10g.php

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)