difference between the Alert file and the Trace file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: difference between the Alert file and the Trace file

Hybrid View

  1. #1
    Join Date
    Oct 2002
    Posts
    109

    difference between the Alert file and the Trace file

    Hi Friends
    What is basic difference between the Alert file and the Trace file?
    Trace file is created by the user process and is written to USER_DUMP_DEST.
    Alert file is created by server process and written to BACKGROUND_DUMP_DEST.
    I am little bit confuse,can u help me
    Regards
    praveen

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    If a server or background process detects an internal error then it is written to a trace file - also tracing information is written to trace files.
    The alert log is a chronological log of messages and errors from the database. Includes things like startups/shutdowns, admin operations, ORA-0600 messages etc - best to read the concepts manual for a proper list

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by fraze
    If a server or background process detects an internal error then it is written to a trace file - also tracing information is written to trace files.
    These trace files (server or backuground trace files) are generated in BACKGROUND_DUMP_DEST.

    The user trace files are generated in USER_DUMP_DEST.

    prav_saras the basic difference is what u said ur self

    Trace file is created by the user process and is written to USER_DUMP_DEST.
    Alert file is created by server process and written to BACKGROUND_DUMP_DEST.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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