Re: Fw: 9i doubts

From: Jared Still <jkstill_at_cybcon.com>
Date: Tue, 06 May 2003 15:16:38 -0800
Message-ID: <F001.00591CED.20030506151638@fatcity.com>

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: Jared Still
  INET: jkstill_at_cybcon.com

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 Tue May 06 2003 - 18:16:38 CDT