Re: application deadlock ORA-00060
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: sol.beach@xxxxxxxxx
- Date: Wed, 9 Apr 2008 17:53:14 -0400
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@xxxxxxxxx> 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
Other related posts:
