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: After enlarge the memory

Re: After enlarge the memory

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 13 Sep 1999 08:21:06 GMT
Message-ID: <37dcb381.16898651@news.earthlink.net>


run svrmgrl
do
SVRMGR> show sga
you'll get the idea
your init.ora should be something like
$ORACLE_HOME/dbs/init$ORACLE_SID.ora
but should actually be stored in
$ORACLE_BASE/admin/$ORACLE_SID/pfile/init$ORACLE_SID.ora these are pretty much defaults and OFA compliant

On Mon, 13 Sep 1999 15:45:55 +0800, "FAI" <leemingf_at_pacific.net.hk> wrote:

>But i found that there is no such parameters in two init.ora.
>Are they running with the default setting?
>
>
>Mario Bucsics <mario.bucsicsNOmwSPAM_at_siemens.at> wrote in message
>news:098f8f78.e9c9b33e_at_usw-ex0102-010.remarq.com...
>> If your Database is running well i would leave the
>> configuration as it is otherwise i would prefer to give my
>> db more memory set by the parameters shared_pool_size ,
>> db_block_buffers.
>>
>>
>> Mario Bucsics
>>
>> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
>*
>> The fastest and easiest way to search and participate in Usenet - Free!
>>
>
>


Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Mon Sep 13 1999 - 03:21:06 CDT

Original text of this message

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