Re: Memory Limit Imposed on Oracle by Windows?

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. Received on Fri Apr 20 2007 - 06:40:51 CDT