Why we use Sort_area_size parameter in init.ora file?Kindly let me know?

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

SORT_AREA_SIZE is one of the deferred Oracle Server Parameters which is set in init.ora. Its value as bytes (integer) sets the size of in-memory sort work area. The default is 64K and the maximum valu...

Answer Question  Select Best Answer