RE:

[dieter . oberkofler]

hi bjorn!   you might have a look to my Top100 tool that works great for the "top-statements". have a look at : http://www.materialdreams.com/products.html and check it out.   -do -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bjorn Naessens Sent: Monday, February 19, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Subject: 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