TOP SESSIONS?

hi,

  in oracle you would use these two cursors to determine who was
connected and

what they were doing.


select distinct s.sid sid, s.serial# serial, s.status status, osuser,
spid ,

                count(o.sid) counter, s.username username, s.program
program, sql_address

          from v$session s, v$open_cursor o, v$process p

         where s.sid = o.sid(+)

           and paddr = addr

         group by s.sid,s.serial#, s.status , osuser, spid ,s.username,
s.program ,sql_address

         order by 1,3


select distinct name

  from sys.audit_actions, v$sqltext

 where address = ?

   and action = command_type



<bold><color><param>0000,0000,8080</param><bigger>does anyone know what
tables in postgres would give me the same or similar information?


</bigger></color></bold>TIA,

   mikeo