super-expensive query ?

From: Ed <ed_at_mail.com>
Date: Thu, 22 Feb 2007 13:23:24 -0500
Message-ID: <12trnsthpqfrmb2@corp.supernews.com>

why is this QUERY so goddamn SLOW ???
Is this a super-expensive query or what ?

select b.username,c.sid,c.owner, c.object,b.lockwait,a.sql_text

from v$sqltext a,
     v$session b,
     v$access  c,
     v$locked_object d,
     dba_objects e
where  a.address=b.sql_address
and    a.hash_value=b.sql_hash_value
and    b.sid=c.sid
and    d.object_id=e.object_id

and e.object_name=c.object
and c.owner!='SYS'
order by b.username ;

10gR2 Received on Thu Feb 22 2007 - 12:23:24 CST