On Feb 22, 1:23 pm, "Ed" <e..._at_mail.com> wrote:
> 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
Runs fairly fast on 10R1 (~10ms) - returns nothing though. What is
your explain plan?
Received on Thu Feb 22 2007 - 12:31:12 CST
