Which Trace File Is Used For Performance Tuning And Why?

1.	Which Trace File Is Used For Performance Tuning And Why?
Answer» User process trace file is USED for performance TUNING because it CONTAINS INFORMATION about execution plan and resource consumption. This information can be used for performance tuning. These files are located in the directory specified in the BACKGROUND_DUMP_DIRECTORY parameter. User process trace file is used for performance tuning because it contains information about execution plan and resource consumption. This information can be used for performance tuning. These files are located in the directory specified in the BACKGROUND_DUMP_DIRECTORY parameter.

Answer»

User process trace file is USED for performance TUNING because it CONTAINS INFORMATION about execution plan and resource consumption. This information can be used for performance tuning.

These files are located in the directory specified in the BACKGROUND_DUMP_DIRECTORY parameter.

User process trace file is used for performance tuning because it contains information about execution plan and resource consumption. This information can be used for performance tuning.

These files are located in the directory specified in the BACKGROUND_DUMP_DIRECTORY parameter.

Discussion

No Comment Found

Related InterviewSolutions

How Can You Detect Block Corruption?
How Do You Handle Ora-01403: No Data Found Error?
What Are The Different Types Of Locking Modes?
Name A Few Places You Will Look To Get More Details On A Performance Issue?
Describe The Oracle Wait Interface?
How Can You Monitor Performance Of The Database Proactively?
Which Trace File Is Used For Performance Tuning And Why?
What Do The Db_file_sequential_read And Db_file_scattered_read Events Indicate?
What Do You Understand By Db File Scattered Read?
What Is The Main Reason For Block Corruption?