Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALTER SYSTEM SET SQL_TRACE=TRUE

Jorgeff87Jan 14 2015 — edited Jan 14 2015

Hi all,

I have a procedure that is taking so so long to execute in one database client, but this doesn't happens in many others, it executes immediatly. When I modify the procedure inserting "ALTER SYSTEM SET SQL_TRACE=TRUE" in the beggining and "ALTER SYSTEM SET SQL_TRACE=FALSE" in it ends, it executes immediatly. I've read that enabling trace is a way to tunning, but I'd like to know the disadvantages of it.

Thank you very much.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 11 2015
Added on Jan 14 2015
6 comments
4,285 views