Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Issy les Moulineaux, France
    Posts
    24

    Unanswered: Can't set SQL_trace to TRUE

    Hi,

    I can't make any tkprof on my base.

    IN SQL/PLUS :
    SQL> alter session set sql_trace = true;
    Session altered.
    SQL> show parameter sql_trace
    sql_trace boolean FALSE

    And of course, no trace generated.

    I don't understand.

    Any ideas ?

    Thanks.

    Database is Oracle 9.2.0.4.0

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    you won't see the parameter as changing regardless.

    However, if you are not generating trace files then there is definitely a problem. I assume you set sqltrace=TRUE and then ran some code. You then went to the host server UDUMP directory and there were no trace files. Correct?

    As what user are you doing this?

    Does "set autotrace traceonly explain" work?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jan 2004
    Posts
    370
    Originally posted by The_Duck
    you won't see the parameter as changing regardless.

    The Duck is right.
    There are some parameters which show the SYSTEM level setting rather than the SESSION level setting when you query them, and sql_trace is one of them.

  4. #4
    Join Date
    Jan 2004
    Location
    Issy les Moulineaux, France
    Posts
    24
    Thanks for your reply.

    sql_trace was active.

    Finally, I've found the trace files but in $ORACLE_HOME/rdbms/log,
    not in the directory set in parameter USER_DUMP_DEST.

  5. #5
    Join Date
    Jan 2004
    Location
    Germantown, MD
    Posts
    34
    If you are traking a BACKGROUND session than the trace files are created in BACKGROUND_DUMP_DEST. Perhaps that is what was happening...

    To make finding the files easier, I use the following command:
    alter session set tracefile_identifier='foobar';

    This will create a trace file name similar to: mydb_ora_4758_foobar.trc

    Now you can grep for foobar and find your traces...

    -Vaughn
    "The world is a dangerous place, not because of those who do evil, but because of those who look on and do nothing. "
    - Albert Einstein

Posting Permissions

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