>From the OS pmap >From the DB select * from v$sesstat where stat# in ( select stat# from v$statname where name like '%ga%' )
hth connor --- CP <[EMAIL PROTECTED]> wrote: > Hi Gurus, > > How can I find out the amount of memory utilized > (grabbed from the > available memory of the OS) by a server process, > whenever a user > establishes a connection with the database. The OS > is Sun Solairs with > Oracle version 8.1.7.3. In other words, if I have a > unix process id, is > there a way to find out how much memory it is > consuming. > > Thanks for your help and time in advance. > > CP > > > > > [EMAIL PROTECTED] wrote: > > >OS: Solaris 2.7 > >Database: 8.1.7 > > > >On dev server, !ls from sqlplus gives the files of > current directory where > >sqlplus runs. > >On pro server, !ls from sqlplus goes to the home > directory of os user. > > > >For example, > >Login to sqlplus from /u01 on both machines, > >on dev: SQL> !pwd > > /u01 > > > >on pro: SQL> !pwd > >/export/oracle > > > >What seting affects this ? > > > >Thanks, > > > >-Li Zhang > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: CP > 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). ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
