Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2006
    Posts
    31

    Unanswered: How to turn off tracing in Oracle 10.2.0.4?

    Hi all,

    I turned on tracing through Grid Control and turned it back off. However, even though it's shown as turned off in Grid Control, it's still shown as turned back on in the database and the trace files get generated. How can I turn it off?

    SQL> select trace_type, primary_id, waits, binds, instance_name from dba_enabled_traces;

    TRACE_TYPE PRIMARY_ID WAITS BINDS INSTANCE_NAME
    --------------------- ---------------------------------------------------------------- ----- ----- ----------------
    SERVICE_MODULE ODSPRDR1_KE TRUE FALSE ODSPRDR12


    Thanks in advance,
    Alla

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    did you reboot this server?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2006
    Posts
    31
    no, I didn't. It couldn't turn off tracing in Grid Control and I restarted the agents on the target and Grid Control machine. I tried to turn tracing off again in Grid Control and it finally succeeded, but I still see it turned on in the database. How can I fix this?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    sessions that started when tracing was enabled, will continue to trace until they terminate.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Nov 2006
    Posts
    31
    this is interesting to note! I just matched the sid,serial# from the trace files to the existing running sessions in v$session and it turns out that sql_trace column is set to DISABLED for all of them and these sessions are still generating trace. Is it a well documented bug or an expected behavior?

  6. #6
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Which version of GC are you using? Previous experience with GC 10g taught me that GC doesn't always do what you want it to do, what it says it will do, nor what it says it has done. GC 11g is much better
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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