memory for oracle client?

From: andrew <member_at_dbforums.com>
Date: 2 Apr 2002 13:11:29 GMT
Message-ID: <3ca9ae01$1@usenetgateway.com>

Hi all,

USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND oracle 19168 0.5 6.0 42096 11484 - A 18:00:42 0:02 ora_ckpt_uat oracle 31342 0.0 6.0 42108 11500 - A 18:00:42 0:00 ora_reco_uat oracle 30080 0.0 6.0 42112 11508 - A 18:00:42 0:00 ora_smon_uat oracle 32442 0.0 6.0 42340 11740 - A 18:00:42 0:00 ora_lgwr_uat oracle 34208 0.0 7.0 42844 12232 - A 18:00:42 0:00 ora_dbw0_uat oracle 33970 0.0 2.0 6160 3044 pts/1 A 18:03:04 0:00 sqlplus system/ma <------- oracle 32706 0.0 6.0 42524 11920 - A 18:03:05 0:00 oracleuat (D oracle 25650 0.0 8.0 45508 14892 - A 18:00:41 0:00 ora_pmon_uat

RSS is the real memory spend by the Oracle client. Here the sqlplus session is using 3044K bytes of memory? but how about the PGA and UGA? does this memory here included in the UGA or PGA?

thanks

andrew

--
Posted via dBforums
http://dbforums.com

Received on Tue Apr 02 2002 - 07:11:29 CST