Re: Memory Limit Imposed on Oracle by Windows?

dbaplusplus_at_hotmail.com wrote:

>>> One should, of course, use memory wisely, but making good use of large
>>> amount of memory can help the performance as well.
>> Using large amounts of memory won't help ever, if you have an
>> unscalable application, and don't know how to tune your statements.
>> If you have tuned your statements, you won't need 8 Gb buffer cache
>> ever.
>>
>> --
>>
>> Sybrand Bakker
>> Senior Oracle DBA

> 
> In real world of ERP's and pacakged applications, you do not have
> access to source code, cannot tune sql statements

The OP has 10gR2 so your state is not valid. There are numerous ways to tune a statement without access to the source code.

One among this is advanced rewrite:
http://www.psoug.org/reference/dbms_adv_rewrite.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org