QUERY IS running slow

 Description:    This script will show you the user's OS name, Username in the database and the SQL Text they are running

Code:

    SELECT osuser, username, sql_text

    from v$session a, v$sqltext b

    where a.sql_address =b.address

    order by address, piece

PGA usage

"

-this should be accurate

select name, sum(value/1024) "Value - KB"

from v$statname n,

v$session s,

v$sesstat t

where s.sid=t.sid

and n.statistic# = t.statistic#

and s.type = 'USER'

and s.username is not NULL

and n.name in ('session pga memory', 'session pga memory max',

'session uga memory', 'session uga memory max')

group by name;