Re: Memory Limit Imposed on Oracle by Windows?

On Apr 21, 4:16 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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
>
> 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
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

I do not know what you are referring to you on your Web_sites. Standard tehniques for sql tuning when you do not have access to source code:

a. Add indexes
b. Use materilaized views
c. Use outln

If you have access to source code, you can do lot better because all above techniques have limitatiosn. Received on Sat Apr 21 2007 - 19:30:08 CDT