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: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 13 Sep 1999 08:25:33 -0700
Message-ID: <37DD176D.6BFC6BE1@us.oracle.com>


Probably. Try looking at v$parameter (there is a column IS_DEFAULT to tell you whether they are or not). Almost certainly, if they're still at default values they will be too low for a real Production system.

Pete

FAI 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!
> >


Received on Mon Sep 13 1999 - 10:25:33 CDT

Original text of this message

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