High Sorts On Disk Wait

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

The result table for a sort operation could not be completed in memory and was performed on a temporary tablespace.

High sorts on disk findings

	Description
What to do next	In the Activity workspace, examine temporary tablespace   overtime I/O consumption, and the statements using temporary tablespace I/O.
Advice	To reduce the I/O consumption for the sort operation, consider the following solutions: n   Change the SORT_AREA_SIZE to a higher value. If you are using PGA settings, you can change the PGA_Aggregated_Target, so as to avoid sort and hash area size problems. You can either change the values for a specific session, using the Alter Session command, or for the entire instance. n   Try to identify statement-originated sorts. If there are many sorts located in a few statements, try to solve the problem at the statement level by doing one of the following: •   Add an index to prevent a sort. If your statement has an Order by clause that has columns for a single table, check whether you can add an index. In some cases, you may get an index recommendation that prevents a sort. If you are considering adding an index, check the effect of adding that index in the What-If workspace. •   Identify the heavy sort or hash consumer step. Run a statement with statistics_level=all. Click the Run and Compare tab. Examine LAST_TEMPSEG_SIZE and MAX_TEMPSEG_SIZE in the extended section of the run results. Change the SORT_AREA_SIZE to a higher value.

Get Oracle Certifications for all Exams
Free Online Exams.com