Re: memory for oracle client?

andrew <member_at_dbforums.com> wrote in message news:<3ca9ae01$1_at_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

No, the PGA and UGA are located in the background process serving this client session (non-MTS config) or in the SGA (MTS config) You could query those from v$sesstat or v$mystat in your session

Hth

Sybrand Bakker
Senior Oracle DBA Received on Tue Apr 02 2002 - 13:02:39 CST