Re: Memory?

I have an idea ..
PGA = UGA(user_session_data + cursor state)+stack space

So Will it be enough or do I have to add sort_area_size to the value below?

select * FROM v$SESSTAT a ,v$STATNAME b WHERE a.statistic#=b.statistic# and name like 'session pga memory' ;

Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729

The degree of normality in a database
is inversely proportional to that of its DBA.

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, April 24, 2002 4:43 PM

> Sergey,
>
> Attachments are not going through on this list.
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, April 24, 2002 2:58 AM
>
>
> > Hello Clinton,
> >
> > Here is script for calculating memory requirements (shared pool
> > requirements).
> >
> > Tuesday, April 23, 2002, 5:38:33 PM, you wrote:
> >
> > CN> Hi all.
> >
> > CN> Does anyone have any idea how to calculate the amount of memory each
> user
> > CN> uses during a session?
> > CN> This needs to be done to calculate the amount of memory Lawson will
> use
> > CN> during production.
> >
> > CN> Any help given will be appreciated.
> >
> > CN> Thanks
> >
> > CN> Clint
> >
> >
> > CN> Confidentiality Warning
> >
> > CN> =======================
> >
> > CN> The contents of this message and any attachments are intended solely
> for the
> > CN> addressee's use and may be legally privileged and/or confidential.
If
> you
> > CN> are not the addressee indicated in this message, any retention,
> > CN> distribution, copying or use of this message is strictly prohibited.
> If you
> > CN> received this message in error, kindly notify the sender immediately
> by
> > CN> reply e-mail and then destroy the message and any copies thereof.
The
> > CN> content and any views expressed therein are, unless otherwise
stated,
> the
> > CN> views of the author and not those of the company or any of its
> management or
> > CN> directors.
> >
> > CN> Whilst all reasonable steps are taken to ensure the accuracy and
> integrity
> > CN> of information transmitted, the company does not accept
responsibility
> for
> > CN> any corruption of the information or data or breach of
confidentiality
> as a
> > CN> result of electronic submission.
> >
> > CN> When addressed to the Momentum Employee Benefits clients any opinion
> or
> > CN> advice contained in this e-mail is subject to the terms and
conditions
> > CN> expressed in any applicable terms of business.
> >
> >
> >
> >
> >
> >
> >
> > --
> > Best regards,
> > Sergey mailto:dsv_at_pptus.oilnet.ru
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Igor Neyman
> INET: ineyman_at_perceptron.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bunyamin K. Karadeniz
  INET: bunyamink_at_havelsan.com.tr

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).