Re: Memory Limit Imposed on Oracle by Windows?

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 22 Apr 2007 11:19:20 -0700
Message-ID: <1177265961.215116@bubbleator.drizzle.com>

dbaplusplus_at_hotmail.com wrote:
> 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.

Did you read the original the text to which I was responding?

Here it is:
"In real world of ERP's and pacakged applications, you do not have access to source code, cannot tune sql statements"

There are many appropriate responses to that statement. None of them include doing better if you have access to the source code.

-- 
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

Received on Sun Apr 22 2007 - 13:19:20 CDT