Sunday, 22 April 2012

Which trace file is used for performance tuning and why? | Oracle DBA

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.

No comments: