Sorry... I'm using 9.0.1.4
I will look into PGA_AGGREGATE_TARGET.
Thanks,
Bart
>>> [EMAIL PROTECTED] 06/25/03 10:24AM >>> You didn't specify which version of Oracle
you are using, but if it's 9i then you should investigate the use of
pga_aggregate_target instead of the older sort_area parameters. I've been
using pga_aggregate_target in a hybrid OLTP/reporting database for about 8
months with great results. Mine is set to 100 MB. You'll get the
benifit of the memory advice feature of 9i as well. Have a look at OEM if
you're using it, otherwise you can look directly in the dictionary views to
determine proper sizing of PGA, shared pool, and buffer cache.
Best regards, David B. Wagoner -----Original
Message-----
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 |
- 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
- RE: SORT_AREA_SIZE question DENNIS WILLIAMS
- RE: SORT_AREA_SIZE question John Kanagaraj
- RE: SORT_AREA_SIZE question Rajesh . Rao
- Re: SORT_AREA_SIZE question Tanel Poder
- Re: SORT_AREA_SIZE question Binley Lim
- Re: SORT_AREA_SIZE question Rajesh . Rao