1.

What Is A User Process Trace File?

Answer»

A user process trace file is a trace file that is produced by user session. HOWEVER, this is an optional file, which is generated if the user wants to generate the file. This file is generated when the value of SQL_TRACE PARAMETER is SET to TRUE for a session.

  1. This parameter can be set at DATABASE, instance, or session level.
  2. If it is instance level, trace file will be generated for all the connected sessions.
  3. If it is set at session level, trace file will be generated only for the specified session.
  4. The LOCATION of user process trace file is specified in the USER_DUMP_DEST parameter.
  5. The information in user process trace file is generally used for trouble shooting.

A user process trace file is a trace file that is produced by user session. However, this is an optional file, which is generated if the user wants to generate the file. This file is generated when the value of SQL_TRACE parameter is set to TRUE for a session.


Discussion

No Comment Found

Related InterviewSolutions