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 <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 4:43 PM > Sergey, > > Attachments are not going through on this list. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > 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:[EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Igor Neyman > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).