Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Fw: 9i doubts
Hi and thanks I wasn't expecting a complete query to find out the
dynamically sizeable components ,
Ok now answer me this (its a conceptual question) when a layman asks you to
name the components of sga which are dynamically sizeable which ones would
you name ?
Would you say
1. shared pool 2. data buffer cache 3. large pool
>
> Yes, a few at a time would be better.
>
> Here's Q1:
>
> The following query will show which SGA components
> are dynamically sizable. I'm fairly sure that these are
> all type 6, as type 6 indicates that the value is a 'big integer'.
>
> select
> name
> , value
> , decode(isdefault, 'TRUE','Y','FALSE','N','?') isdefault
> , decode(
> isses_modifiable
> ,'TRUE','Y'
> ,'FALSE','N'
> ,'?') isses_modifiable
> , decode(
> issys_modifiable
> ,'FALSE','N'
> ,'DEFERRED','D'
> ,'IMMEDIATE','I'
> ,'?') issys_modifiable
> from v$parameter
> where type = 6
> and issys_modifiable != 'FALSE'
> order by name;
>
> Jared
>
>
> On Monday 05 May 2003 09:37, bulbultyagi_at_now-india.net.in wrote:
> > Jared I know , I ask too many questions
> > I can try out question 6 and find out
> > Most of the others were theoretical questions
> > I had these doubts after going through the Oracle 9i release 2
> > documentation.
> > If anyone knows anything about these questions please let me know, I
asked
> > a lot of people and read a quite a few manuals
> > .........
> > Would it be better if I asked a few questions at a time ?
> >
> > > ----- Original Message -----
> > > From: "Jared Still" <jkstill_at_cybcon.com>
> > > To: <ORACLE-L_at_fatcity.com>; <bulbultyagi_at_now-india.net.in>
> > > Sent: Sunday, May 04, 2003 07:45
> > > Subject: Re: 9i doubts
> > >
> > > > why not build a 9i database, test each of these, and
> > > > let us know the results?
> > > >
> > > > Sorry, too many questions for me, some of which the
> > > > answers are easily ascertained from the documentation.
> > > >
> > > > Jared
> > > >
> > > > On Friday 02 May 2003 22:56, bulbultyagi_at_now-india.net.in wrote:
> > > > > Hello list
> > > > > I had some doubts I had after going thru Oracle documentation for
9i
> > > > > release2 :
> > > > >
> > > > >
> > > > > Q1. Which components of the sga other than the shared pool and
the
> > > > > database buffer cache are dynamically sizable ?
> > > > >
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <bulbultyagi_at_now-india.net.in INET: bulbultyagi_at_now-india.net.in Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri May 09 2003 - 15:59:18 CDT