assotiating SQL text from the V$%SQL% views with sessions

From: Doron <doron_almog_at_msn.com>
Date: 13 Jan 2004 14:38:54 -0800
Message-ID: <995517bc.0401131438.26d1ba68@posting.google.com>

Hi,
Is there any way to associate SQL text from the V$%SQL% views with sessions.

A piece of code in our application locks up a critical table about once a month. I suspect that the code is not committing one or more transactions on that table.

I can find out which session is locking that specific table and I can detect the locking of the table about 2 min after it happens. I tried looking at V$%SQL% views but couldn't associate code with sessions.

I'm not permitted to trace changes to that specific table (or any other table).

Is there a way of associating code with SID or time/timestamp via the V$%SQL% views (or any other views).

Thanks,
Doron Received on Tue Jan 13 2004 - 16:38:54 CST