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.