On of our applications is reporting a problem trying to access on a record
in a table. The application is reporting that a transaction is reserved for
update. The app in question hung whilst working on the record a few days
ago. I'm not convinced that this is an Oracle problem, i.e. a row lock of
some sort, as I've had a peek at DB level via v$lock and v_$locked_object,
v$access but can't seem to find any locks on the table in question. If it
is an Oracle lock of some type how can I identify it?. The database gets
shutdown every night for COLD backups but the app prog in question is
reporting problem for number of days now. Is it possible that some session
might still be haunting around?.
Would appreciate any advice/help on this one folks?.
Sean :)
Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
-------------------------------- ------------
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode]
Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
"Nobody loves me but my mother... and she could be jivin' too." - BB King
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
