Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2005
    Posts
    2

    Unanswered: how to stop Oracle create *.trc files in then udump dir?

    or other dump dirs?
    thanks very much

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    A trc file in udump is only generated when an error is generated, It is turned on globally by setting SQL_TRACE in the spfile or ini file, or the user delibertly turns on tracing. Find out what is going on and attack it from that end. Trace files are important when database errors are generated.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    you can change the udump location.

    alter the user_dump_dest parameter.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by The_Duck
    you can change the udump location.

    alter the user_dump_dest parameter.
    True, you can set the destination to /dev/null on a unix system and throw away all trace files. However, I still think you should find out why the trace files are being generated.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    I think we are both confused.
    The poster doesn't really give enough information. We don't even know if MANY traces are being generated, or if they just want to stop traces no matter what.

    Maybe someone has the database tracing set on.

    look at these parameters which affect trace files:
    oracle_trace_enable
    sql_trace
    max_dump_file_size
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  6. #6
    Join Date
    Mar 2005
    Posts
    2
    thanks .
    the oracle is running in windows2k server.
    sometimes,the .trc file is very huge,and fills up the disk..
    now i just want to stop it no matter what.

Posting Permissions

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