How to trace all the database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: How to trace all the database

  1. #1
    Join Date
    Jun 2006
    Posts
    31

    How to trace all the database

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    set sql_trace = true at the system level - be warned for a lot of output though

  3. #3
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    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"?
    Assistance is Futile...

  4. #4
    Join Date
    Jun 2006
    Posts
    31
    I don't have many users, I want to trace all the database only some minutos or can be that only one minute.

  5. #5
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349

    Arrow

    Don't forget to set timed_statistics to TRUE with SQL_TRACE = TRUE
    http://www.perf-engg.com
    A performance engineering forum

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    timed statistics should always be true anyway

  7. #7
    Join Date
    Jun 2006
    Posts
    31
    Yes, that parameters I have correct, but, what sql is that i have to execute?

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    set sql_trace = true in the parameter file and restart the database

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width