Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Foolish Question about SGA_MAX_SIZE
leo_at_tech-trans.com wrote:
> sjaffarhussain_at_gmail.com 寫道:
>
>>>>> Unfortunately, it cause Oracle stop >> Did you do it during the heave business hrs, which cause oracle to >> stop? >> sga_max_size is not a dynamic parameter, it has to be changed in the >> init/spfile and restart the database. >> Keep little margin of sga_max_size of the total of >> (buffer_cache,shared_pool,java_pool) >> >> leo_at_tech-trans.com wrote: >>> Hi! >>> >>> I tuned the parameter of memory (sga_max_size) in Oracle 9i. >>> Unfortunately, it cause Oracle stop. How can I do? One more question, >>> any guideline to define the maximum of sga_max_size? Thx! >>> >>> Ming
Do the following:
HTH,
Brian
-- =================================================================== Brian Peasland oracle_dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Wed Jun 21 2006 - 22:18:00 CDT