No, I'm a french canadian (Quebec, Canada) currently
working in France , it's currently 14:45 .
Stephane
- Oweson Flynn <Oweson.Flynn_at_liberty.co.za> a
écrit : > Thanx,
>
> I have a copy of it, and will study it further
> tonight!
>
> Looks like you and I are the only two on the list at
> the moment! I am in
> South Africa, where it is almost 12 noon - where are
> you - in the states?
>
> Regards
> Oweson Flynn
>
> Certified Oracle DBA
> The Flynn Consultancy
> Tel: 082-600-7-006
> Fax: (011) 782-9313
> EMail: oef_at_icon.co.za
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: Thursday, January 25, 2001 11:20 AM
>
>
> Hi,
>
> The uga,pga stuff is very well explained in Steve
> Adams book.
> My book is at home (pretty usefull isn't), but by
> memory if you're not using MTS, the size of
> hash_area_size and sort_area_size will be taken in
> the
> user's process. This is a script I used for
> monitoring
> that :
>
> undefine uti
> select ses.sid, substr(s.username,1,15) uti,
> substr(stat.name,1,30) stat,
> round(ses.value/1024) as "Value K"
> from v$sesstat ses,
> v$statname stat,
> v$session s
> where ses.statistic# = stat.statistic#
> and stat.name in ('session pga memory', 'session
> pga
> memory max','session uga memory')
> and s.sid=ses.sid
> and s.username like upper('%&uti%')
> order by uti, ses.sid,stat.name
> ;
>
>
> --- Oweson Flynn <Oweson.Flynn_at_liberty.co.za> a
> écrit : > Hi Gang,
> >
> > I gave the DBA course last week, and one of the
> > students asked what he could
> > do to configure the size etc. of the PGA. I
> thought
> > I had seen some
> > initialisation parameters which affected the size
> of
> > the PGA, but did some
> > research and couldn't find anything.
> >
> > The 8i docs that I have say
> > 'A PGA is allocated by Oracle when a user connects
> > to an Oracle database and
> > a session is created, though this varies by
> > operating system and
> > configuration. ' and 'A PGA's initial size is
> fixed
> > and operating-system
> > specific. '
> >
> > The only thing I could find was 'The
> initialisation
> > parameters OPEN_LINKS
> > and DB_FILES affect the sizes of PGAs. The size of
> > the stack space in each
> > PGA created on behalf of Oracle background
> processes
> > (such as DBW0 and LGWR)
> > is affected by some additional parameters' - but
> > that is for background
> > processes, not the server process!
> >
> > I understand that in an MTS configuration, the
> > 'Session Information' is
> > stored in the SGA, but there is still a (reduced)
> > PGA for each shared Server
> > process.
> >
> > In the article posted on the list (what was the
> > source of it?) on the
> > Architecture of Oracle on NT, it was mentioned
> that
> > you could use the
> > ORASTACK utility to reduce the size of each
> thread's
> > stack (and thereby
> > reduce the size of the PGA).
> >
> > It is also applicable to other operating systems
> > (i.e., Unix)?
> >
> > If anybody can shed more light on the subject, I
> > would much appreciate it!
> >
> >
> > Regards
> > Oweson Flynn
> >
>
> > Certified Oracle DBA
> > The Flynn Consultancy
> > Tel: 082-600-7-006
> > Fax: (011) 782-9313
> > EMail: oef_at_icon.co.za
> >
> >
> >
> >
>
> >
> > This message may contain information which is
> > confidential and subject to legal privilege. If
> you
> > are not the intended recipient, you may not
> peruse,
> > use, disseminate, distribute or copy this message.
> > If you have received this message in error, please
> > notify the sender immediately by email, facsimile
> or
> > telephone and return and/or destroy the original
> > message.
> >
> >
>
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Oweson Flynn
> > INET: Oweson.Flynn_at_liberty.co.za
> >
> > Fat City Network Services -- (858) 538-5051
> FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>
> > 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).
>
>
> =====
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - Buy the things you want at great
> prices.
> http://auctions.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
>
>
>
=== message truncated ===
Received on Thu Jan 25 2001 - 07:48:20 CST
