Re: Memory Limit Imposed on Oracle by Windows?

On 20 Apr 2007 04:40:51 -0700, dbaplusplus_at_hotmail.com wrote:

>On Apr 20, 1:14 am, sybra..._at_hccnet.nl wrote:
>> On 19 Apr 2007 17:16:00 -0700, dbaplusp..._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
>Even when you can tune sql satements, memory can still reduce disk i/
>o. People who talk about main memory databases or real time databases
>(Oracle's ten time ?) are not stupid.
>
>I support a EMC Documentum based Oracle databases. we have no access
>to source code, I found memory and outln techniques to be life saver.

Read some Hotsos materials, and/or the books of Craig Shallamer and stop spreading your dangerous fairy tales.

-- 
Sybrand Bakker
Senior Oracle DBA