Re: 11g

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 19 Sep 2006 16:38:22 -0700
Message-ID: <1158709100.601401@bubbleator.drizzle.com>

JT wrote:
>
> DA Morgan wrote:

>> JT wrote:
>>> Anyone have any ideas of what will be incorporated into 11g? Will it 
>>> be another massive bloated pig that will require bigger capacity 
>>> machines to be bought obsoleting existing hardware - bought and paid 
>>> for?
>>>
>>> Is there anyway to slim down a 10g installation to reduce memory 
>>> usage aside from not running em?
>>>
>>> Can Oracle 8.1.7 or 8i and the latest patches still be downloaded?
>>>
>>> Thanks
>>
>> I would hardly call 10g, which fits on one CDROM a bloated pig. But 11g
>> will not be substantially different from 10g in terms of hardware
>> requirements TTBOMK.
>>
>> If you are worried about memory usage, I run 10gR2 on notebooks with
>> only 512MB RAM, learn to alter parameters in the init.ora/spfile.

>
> Are there any quick and dirty HOWTO links or FAQs that deal with
> tweaking init.ora to consume less memory without affecting performance
> drastically?
>
> Thanks

col name format a40
col value format a40
set linesize 121

SELECT name, value
FROM gv$parameter
WHERE name LIKE '%sga%';

To learn how to change these values read the docs at tahiti.oracle.com or the demos in Morgan's Library at www.psoug.org under spfile.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Tue Sep 19 2006 - 18:38:22 CDT