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
http://www.free-online-exams.com
Statement resources are spent performing sort operation.
| Heavy Sort finding |
| Description | |
| What to do next | Perform one of the following options: n Click the Locate icon to focus on the relevant step in the execution plan. n Select the finding type to investigate step statistics and resource consumption in the Statistics tab. |
| Advice | Try to solve the problem at the statement level by one of the following options: n Add an index to prevent a sort. n 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, you must check the effect of that index. To analyze that effect, launch to the What if workspace. n If the sort involves I/O on the temporary tablespace, you can reduce the I/O consumption for the sort operation by changing 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 area size problems. You can either change the values for a specific session using the Alter Session command, or for the entire instance. |
No comments:
Post a Comment