Internet

Linux

MAC

PC General

Windows

NOTE! Before using any of those informations, be sure you read the Disclaimer! Thank you.

Home » Databases

Oracle – Optimization of sorting

Submitted by No Comment

When we perform a sort operation, we note the increase in I / O to disk. To overcome this increase slows down somewhere the performance of our queries, increase the value of SORT_AREA_SIZE. This parameter specifies the maximum size in bytes of memory Oracle can use to do the sorting. After the sorting operation performed, but before the return of the result, Oracle frees the memory allocated for sorting except the memory specified by the parameter SORT_AREA_RETAINED_SIZE. After the return of the last row of the query result, Oracle releases the remainder of the memory.
Note that the sorting operations are included in the query SELECT DISTINCT, MINUS, INTERSECT and UNION and the level of min (), max () and count ()

Related posts:

  1. Oracle – Oracle architecture components
  2. Query Optimization in SQL Azure Performance
  3. SQL Azure Performance – Query Optimization
  4. Oracle to SQL migration
  5. Dreamcoder for Oracle and Mysql Turbo Manager – Highly Appreciated Software Products for Process Development

Tips and tutorials references:

oracle optimize sort operations , oracle window sort , optimizing sort operations in oracle , how to resolve window sort oracle , window sort in oracle , tuning oracle window sort performance , SORT optimization oracle , slow sorting on windows 2008 server oracle , oracle sort operation is slow , oracle slow sort operation , oracle optimize window sort , oracle optimise window sort , oracle intersect optimize sort , window sort oracle

Leave a Reply