Results 1 to 4 of 4

Thread: 8i Trc - Files

  1. #1
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    25

    Question Unanswered: 8i Trc - Files

    Hi folks,

    a customer of us has the problem of a huge growing database.

    I found that the folder network\trace contains a huge amount (24000 or so) of .trc files.

    Now the question (may be a beginners question, I know):

    What are they good for, and how can I reduce the amount of .TRC - Files ?

    Thanks a lot!

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Trace files are generated when there are database errors or the database session asks to be traced. They provide detail on what happened so that the dba can determine the problem. If you are not using them, there is NO harm in removing them.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    25
    Thanks a lot so far. but is there a way to turn off generating these files ?

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    look into your sqlnet.ora
    seems their is some auditlevel/tracelevel switched on
    switch it off

Posting Permissions

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