Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Posts
    106

    Unanswered: can trace file .trc be deleted

    Hi,

    The trace files in bdump folder are occupying a huge space,Can we delete them??

    Will it affect the normal functioning of oracle.
    Sachi

  2. #2
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    If you do not need them they can be deleted without worry.
    NOTE: Please disregard the label "Senior Member".

  3. #3
    Join Date
    Nov 2004
    Location
    Temple University
    Posts
    36

    Cool

    Sachin;
    Be advised that there was a reason that these files were created. Something is not working correctly. Before deleting the trace files, I would advise going through at least the current ones and try to fix the errors that are being identified. Otherwise, you will keep having the same problem, and never find the solution.

    HTH
    Peter

  4. #4
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Sachin,

    Trace files are not magically created when errors are detected. Trace files are populated as standard practice so that when you notice something is wrong you can go check the pertinent trace files and possibly figure out what is going on. If you are not noticing any troubling behavior you can remove (they will get recreated on the next output) or truncate at your leisure.
    NOTE: Please disregard the label "Senior Member".

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    not to mention every time you set sql_trace to true or if you always have
    sql_trace running.

    it's great for tuning code, but takes up space (as mentioned).
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  6. #6
    Join Date
    Nov 2004
    Location
    Temple University
    Posts
    36

    Cool

    You guy's are absolutely correct. I was thinking about the trace files that are generated when an error is logged to the alert file.

Posting Permissions

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