DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2001


    I am a bit confused with trace file and alert file.

    Are they the same thing??

  2. #2
    Join Date
    Mar 2001

    Trace Files : Trace file can be generated for a particular session or for all session they have extenstion .trc.These files are not readable and to read them you have to use the Tkrpof utility from the command prompt.They are found in the directory where ur user_dump_dest is pointing to in the initialization file.

    Alert files : Alert files are associated with the Instance they trace all activities associated with the database for example startup and shutdown and any block corruption occuring in the tablespaces is recorded,if in case there is a database crash this is the file which you need to look at.This file also contains background process for all the Oracle Background processes.This file will be located in the where ur background_dump_dest is pointing to in the initialization file.

    Hope this helped you


  3. #3
    Join Date
    Jun 2000
    trace is generated for sessions, and associated with each process.
    Alert is associated with overall DB activity
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

  4. #4
    Join Date
    Aug 2000
    Trace files are text files output by the DB to report certain occurances/activities. For example, network and background processes write to trace files when there is a problem. Also, users and DBAs can request trace files be created.

    One special trace file that applies to an entire instance rather than a certain process or user is the alert log.

    Thus trace file = alert log is true, with the above caveats.

  5. #5
    Join Date
    Feb 2001
    For generating trace files
    1)set sql_trace=true
    2)set timed_staistics=true
    3)specify user_dump_destn
    Then only trace files are generated.
    Alert files are generated by the background processes and stored in Background_dump_dest

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.