temporary tablespace --sorting

[lnr]

I dont know i am correct or not

we can specify it in init.ora (SORT_AREA_SIZE) ,we can increase it by looking into the perfomance by

select name, value
from v$sysstat
where name like `sort%

Obviously, the lower the value of the sorts to disk, the better the sort is performing. However, having many sorts to disk does not necessarily mean that the database is not sorting optimally

based on this criteria i can change it i think

If i am wrong please correct me .

Thanks
lnreddy

[sreddy]

You are confusing seems with sorting in Memory and in temp tablespace. Two different concepts.

[url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/tspaces.htm#9566[/url]

[url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76992/ch19_mem.htm#2130[/url]