Is it 9i+ that has the Max SGA Size parameter and then you can "play" with
the Shared Pool , etc parameters via OEM? or does 8i also have that?

Curious -- why 8i when 10gR2 is available or is there a prize awarded for
using the latest hardware but the oldest possible software?

Regards
Amin Adatia ([Email address protected]
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
From: "KLTW_Wilson Shen???"
<oracledba-ezmlmshield-x86963296.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, April 30, 2007 1:45 AM
Subject: RE: SGA


> Hi ,
>
> Please answer following question before we can provide you the
> answer:
>
> 1. How many instnce will you start on this machine ?
> 2. How many concurrent user session will a single instance own ?
>
> Regards
> Wilson Shen
> DBA of KLASER Technology Inc.
> @ SIP , Hsinchu City , TAIWAN
>
> -----Original Message-----
> From: Mohamed Bakali Tahiri
> [mailto:oracledba-ezmlmshield-x55211653.[Email address protected]
> Sent: Monday, April 30, 2007 1:39 AM
> To: LazyDBA Discussion
> Subject: SGA
>
>
>
>
>
>
> Hi
>
>
>
> Can somebody help me,
>
>
>
> I have 4G oin RAM, which size should have the SGA for oracle8i and which
> parameters shoud i change .
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


Oracle LazyDBA home page