Originally posted by Rohit
by using

select a.sid, a.serial#, a.sql_hash_value, substr(c.object_name,1,25) from v$session a, v$locked_object b, dba_objects c where a.sid = b.sessio
n_id and b.object_id=c.object_id

then use the hash value in

select sql_text,
USERS_OPENING,
EXECUTIONS,
USERS_EXECUTING,
LOADS,
FIRST_LOAD_TIME,
INVALIDATIONS,
PARSE_CALLS,
DISK_READS,
BUFFER_GETS
from v$sqlarea where hash_value=upper('&hash_value')


You can combine bothe quieries to directly fetch teh sql if you want to
I suppose u know what u r talking abt???