RE: memory usage

[Koivu, Lisa]

Am I the only one who gets garbage out of this query?  There's a mismatch on v$statname.  Which statistic are you suggesting to display, uga or pga memory? -----Original Message----- From: Bjorn Naessens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 5:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: memory usage solution :   select a.username, b.value from v$session a, v$sesstat b, v$statname c where a.sid = b.sid and b.statistic# = c.STATISTIC# and a.username!='SYSTEM'   ----- Original Message ----- From: Bjorn Naessens To: Multiple recipients of list ORACLE-L Sent: Monday, February 19, 2001 3:25 PM hello dba's ( again )   i'm looking for a way to do a manual "top-session" on a database. According to TopSession from Oracle, the information should be located in v$sessions. Anyone an idea how to read the memory usage out of this table? In v$sess_io i'm able to get the amount of physical reads, but I need the memory usage.   thanks for any help   Bjorn Naessens Roularta IT Solutions