How to trace all the database

[rnavarrc]

Hello all,

I need to trace all my database because I need to know what are executing some proceses that begin when I execute some tasks.

Thanks in advanced

[davey23uk]

set sql_trace = true at the system level - be warned for a lot of output though

[waitecj]

Well, you could create a logon trigger to start tracing as soon as a new session logs on, but depending on how many users you have connecting and what they are doing, you may find your udump directory fills up real quick (you would also have to change MAX_DUMP_FILE_SIZE if it is set to the default).

Better than that, why can't you specify what sessions you NEED to trace, rather than "trace all my database"?

[rnavarrc]

I don't have many users, I want to trace all the database only some minutos or can be that only one minute.

[malay_biswal]

Don't forget to set timed_statistics to TRUE with SQL_TRACE = TRUE

[davey23uk]

timed statistics should always be true anyway

[rnavarrc]

Yes, that parameters I have correct, but, what sql is that i have to execute?

[davey23uk]

set sql_trace = true in the parameter file and restart the database