Hello,
I joined this list last week, so I apologize in advance if I'm asking a
question that has previously been answered.
I am responsible for a reporting database/data mart that is approximately
175 GB. Our main fact table ranges from 1-14 GB depending upon how far
along we are into our financial year. I have large reports that run full
table scans on this table daily. In an effort to keep as much of the
sorting in memory as possible I have specified SORT_AREA_SIZE to be 100MB.
Some of the tuning books I am reading now are making me second-guess myself and
I am wondering if this is overkill.
Can anyone provide some advice on how large they are setting their
SORT_AREA_SIZE values for their DSS systems?
Thanks in advance,
Bart
Please Note
The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you |
- RE: SORT_AREA_SIZE question Bart Kersteter
- RE: SORT_AREA_SIZE question David Wagoner
- RE: SORT_AREA_SIZE question Nigel Bishop
- RE: SORT_AREA_SIZE question DENNIS WILLIAMS
- RE: SORT_AREA_SIZE question Farnsworth, Dave
- Re: SORT_AREA_SIZE question Darrell Landrum
- RE: SORT_AREA_SIZE question Regis Biassala
- RE: SORT_AREA_SIZE question Rajesh . Rao
- Re: SORT_AREA_SIZE question Tanel Poder
- Re: SORT_AREA_SIZE question Tanel Poder
- RE: SORT_AREA_SIZE question Bart Kersteter