Usually such large sort_area_size is used for batch processes, so there is
no problem with many such jobs running at the same time. It can be done
befor e running the job and then back to old value after the job ended. Also
if hash_area_size parameter default value is sort_area_size.
This is why t
Mininmal disadvantages besides overextending the
machine's memory...eg if 100 people are all doing a
large sort at the SAME time, you could have 100 x 10m
of memory or more getting munch up...But the memory is
only used when they want to do a sort ...
hth
connor
--- CC Harvest <[EMAIL PROTECTE
Sent by: Subject: wrong setting of sort_area_size
[EMAIL PROTECTED]
Advantage:increasing sort area size decreases the I/O, hence quicker sorting
process.
Disadvantage: increasing sort area causes sort process to allocate more
memory, which effects the OS memory allocation
resulting in paging and swapping.
large sort area sizes can used if you are using with a mini
we had a customer of the sort_area_size=1000
in their database, the temp table space is 256MB, the
db_block_size is 8k. They have some performance
problem, I think it's probably related to the setting
of sort_area_size(we have only one user). So what's
the benefits/disadvantage of too big sort