Memory utilization

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

lzhang_at_salu.com 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: csp2201_at_netscape.net

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