[Oracle]Optimizing sorting operations

Last update on July 9, 2009 08:13 AM by jak58
Published by jak58

[Oracle]Optimizing sorting operations






You may certainly have noticed that when performing a sorting operation, there is an increase of the number of input/output to disk.


This will somehow slow down the performance of our requests and to counter this we must increase the value of the SORT_AREA_SIZE parameter. This parameter specifies the maximum size in bytes of memory that Oracle can use to perform the sorting. Once the sorting operation performed, Oracle frees the memory allocated for sorting except the memory specified by the parameter SORT_AREA_RETAINED_SIZE (of course before returning the results). After the return of the last row of the result of the query, Oracle frees the rest from memory.

Note that the sorting operations are included in the SELECT DISTINCT, MINUS, INTERSECT, UNION, min (), max () and count ().
Best answers for « Optimizing sorting operations » in :
NETGEAR ProSafe Network Management Software NMS100 - Complete package - 1 user - CD - Win Show
Download RamBoost XP Show
Operating system Show Description of the operating system For a computer to be able to operate a computer programme (sometimes known as application or software), the machine must be able to perform a certain number of preparatory operations to ensure exchange between...
Optimizing Firefox completely ShowOptimizing Firefox completely Intro Increase the speed of loading pages Optimize memory usage Intro Type about:config in the address bar of Firefox, then read and confirm the warning. - To obtain a value, type the name or part...
Installing Opera 10 under Ubuntu 9.04 (Jaunty) ShowInstalling Opera 10 under Ubuntu 9.04 (Jaunty) If you already have an older version of Opera, first remove it: sudo apt-get remove opera (This operation will not results in the lost of your configuration or your bookmarks.) Then do:...
Configuring Opera Mini on Nokia phones ShowConfiguring Opera Mini on Nokia phones Issue Solution Issue You have installed Opera Mini on your Nokia handset and activate your GPRS settings, you cannot connect to browse on Opera Mini! Opera Mini should configured, access points...
Download Opera for Windows ShowPossibilty to download a version compatible with Linux, MacOS, Solaris, FreeBSD ... The Opera Web browser is faster and more secure than IE. It block pop-ups and content you don't want to see. It also offers several new features for...
Download Opera Mini ShowOpera Mini is a web browser for your mobile phone. Simple and easy to use, the application enables you to browse internet quickly. Opera Mini is especially for touch pad phone. The application includes skin customization. Features You can watch...
Download Optimizer XP Show
Operating Systems - MS-DOS - Tips ShowSetting the CD-ROM drive The CD-ROM drive is configured in the config.sys and autoexec.bat system files. The CD-ROM drive device driver must be configured in the config.sys file (even if the device is automatically detected in Windows). To do...
WiFi modes of operation (802.11 or Wi-Fi) ShowThere are several kinds of hardware that may be used to implement a WiFi wireless network: Wireless adapters or network interface controllers (NICs for short) are network cards with the 802.11 standard which let a machine connect to a wireless...
Operating Systems - MS-DOS - Commands ShowCommand Description dir lists the contents of a folder cd changes folder cd .. parent folder md or mkdir creates a new folder deltree deletes a folder and all sub-folders copy, xcopy copies...
They need your help