Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SGA limition

Re: SGA limition

From: Evan Cao <ecao_at_ti.com>
Date: Mon, 05 Oct 1998 14:01:30 -0600
Message-ID: <3619259A.6D4A1EFC@ti.com>


Call ORACLE or go back read the e installation guide, whichever will tell you the details how to do
it.
Basically, you have to make a parameter file change by an oracle utility, and remake oracle.

I have noticed the same issue, but I did not remake them yet. Everybody was telling me that there is no gain if enlarge the SGA to more that 1/4 of the MEM.

good lock.

Evan

PS. If you find some gain after enlarge it, please share it with the group and email me something at ecao_at_ti.com

Alvin Huang wrote:

> Hi,all
>
> I run ORACLE 7.3.4 in DG/UX 4.11 (AV20000)
>
> and i have about 10G memory
> but it seems i can tune my SGA size to 1.7G only.....
> Is it possible to make SGA size greater than 1.7G??!
> If possible,how??
>
> Is there any table or place record all the actions (incluse select)??
>
> Please kindly answer me, THx
>
> Alvin 10.2.98


Received on Mon Oct 05 1998 - 15:01:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US