| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Identifying user and locked table row in Oracle 8i
Tamas - Have you checked out the "User Type Locks Chart" in OEM? I think
that it displays the information you desire. If not, you might look at the
scripts catblock.sql and utllockt.sql in $ORACLE_HOME/rdbms/admin. I haven't
used them, but have seen them mentioned. If you want a script for your users
to run, you may end up writing a script based on what you see in these
scripts. They probably just go after information in the V$ tables.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, October 30, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L
Hi,
I am facing a locking problem with Forms 6i and Oracle 8iR3 that did not occure with Oracle 8iR2.
To pinpoint the problem, I would need to identify the locking user AND the specific record that causes the problem. Does some of you possibly have a script that I can let our customer run when this deadlock situation occures?
TIA,
Tamas Szecsy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Szecsy Tamas
INET: tszecsy_at_GEOMETRIA.hu
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 30 2001 - 14:48:17 CST
 |
 |