| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: large SORT_AREA_SIZE usefullness
Has the larger use of memory resulted in swapping? That could slow things down.
Jim
-----Original Message-----
Poovathummoottil
Sent: Wednesday, June 20, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Hi All,
We have small data warehouse database. Some queries against some fact tables which are in the range of 30 to 40 GB are often causing full table scans. We had the SORT_AREA_SIZE set to 1M and we were seeing a memory sort of 99%. But the number of queries which used the disk sort was around 500 for a week. I plan to increase the sort area size according to the formula given in Steve Adams' website and tested a few queires to use a SORT_AREA_SIZE of 86M and found that all the quries which used the larger sort_area_size actually ran slower than the ones which used 1M sort_area_size.
Could some one explain this behaviour?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: joni_65_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Jun 20 2001 - 12:50:31 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Newman INET: jnewman_at_measurecast.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |