Oracle Technology Blog

OraTech Blog provides tips,tricks,scripts and how-to type answers for Oracle related technologies. I use these commands very often, so I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions.

Friday, December 08, 2006

Resource Intensive Query

select s.sid,s.serial#,s.username,s.program,s.sql_hash_value,s.taddr
from v$session s,v$process p
where s.paddr=p.addr and p.spid=&spid;

select sql_text from v$sql where hash_value in (
select s.sql_hash_value
from v$session s,v$process p
where s.paddr=p.addr and p.spid=&spid);

1 Comments:

Blogger Unknown said...

Cheap Taps UK products are generally excellent semi-bright Antique Tapsplated body on refined copper, bright nickel and chrome plating three layers. Generally, the first copper layer, to enhance adhesion of the plating layer of nickel (including semi-bright nickel and bright nickel) plays a role in corrosion Waterfall Taps. And because the nickel itself is relatively soft and dark color, therefore, will be plated with nickel-chromium layer on layer, while increasing the brightness of the hardened surface Bathroom Sink Taps

4:43 AM  

Post a Comment

<< Home