APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

reports deadlocking on WWV_FLOW_PREFERENCES$

stevepenceAug 21 2007 — edited Jun 21 2010

Hi,
It may be coincidence, but since our upgrade to 3.0 we've had a steady rash of deadlocks in the alertlog on a couple of our very simple report pages. In every case that I've checked, the deadlock was with another session held by the same user. The offending sql reported by oracle is this:

UPDATE WWV_FLOW_PREFERENCES$ SET ATTRIBUTE_VALUE = :B5 WHERE USER_ID = NVL(:B4 ,NVL(:B3 ,USER)) AND PREFERENCE_NAME = :B2 AND SECURITY_GROUP_ID = :B1

I'm guessing this has to do with user picking a sort order. I don't see anything else on the page that could be user related.

Thanks for any suggestions.

Steve Pence
DBA
Wycliffe Bible Translators
Orlando/Chennai

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2010

Added on Aug 21 2007

#apex-discussions

25 comments

5,529 views