Re: application deadlock ORA-00060

Do you have rowid's in your deadlock trace file? these can be used to find rows

that will not work if data for these rowid's has changed after trace was generated though but you can try to use flashback query to see how data was at the deadlock time

On Wed, Apr 9, 2008 at 4:56 PM, sol beach <sol.beach_at_gmail.com> wrote:

> The trace file shows two "identical" statement like the following:
>
> DELETE FROM APP_TABLEA WHERE ID = :1
>
> How can I learn the value of the two bind variables?
>

-- 
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf

--
http://www.freelists.org/webpage/oracle-l