Have a quick question. I want to trace a sql procedure, which is a very small part of a big job and which gets invoked via a process kicked off via the application..

So far, I know how to trace a procedure or a SQL statement, but not this way.

Option 1:
So, if I execute a sql script before the sql procedure, is that enough through the shell script. My sql script would contain 3 lines with
Alter session set sql_trace=TRUE, similarly for Timed_stats and max_dump_file..

Option 2:
Add the same parameters in init.ora file
Bounce the database
Run the job from the application.

I can almost assure there will be no one using the system while the job goes on and that takes about 12 hours..

Tell me the best solution.. If I go for the option 2 and kick off the job, I will be tracing the whole thing DEFINITELY right.. I just want to be sure..

Very urgent. Please respond immediately..

Thanks, ST2000

[Edited by st2000 on 08-14-2002 at 10:19 PM]