Re: memory usage

[Bjorn Naessens]

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