Re: How to get the 'SQL query' which is blocking rows
Date: Fri, 9 Jan 2009 17:22:58 +0100
<l0ll1_at_yahoo.com> a écrit dans le message de news: 20cd350f-f96e-4d40-9fc9-37b2ee1c1ccd_at_q30g2000prq.googlegroups.com...
| Hello All,
| I was able to get to the object using object_id from v$lock.p1 for TM
| type lock. But I actually want the sql query from blocking session
| which locked that objects row(s). For example:
| session 1:
| update table_a ..or select for update.. or delete ...
| select * from table_b ..
| select * from table_c ...
| session 2:
| update table_a...
| At this time, if we run your query on v$sql for blocking session,
| sql_hash_value or prev_hash_value will return select * .. statements.
| But, I wanted to get to the update statement.
| What are my options here? Using blockers SID can we get all the sql
| queries issued by that blocking session from ASH then locate sql
| issuing locks (update/select for update/delete)??? Does any ASH views
| store sid along with sql queries?
Afaik, there is no way.
Michel Received on Fri Jan 09 2009 - 10:22:58 CST