Looking for some advice. Yesterday, a colleague tried to update a row in an Oracle 9i database via Toad. She killed Toad in Task Manager as it hung as Not Responding. Now, when we try to update the row, we get the ORA-00054: resource busy and acquire with NOWAIT specified. We access the database with a VPN connection which has since been disconnected. I'm not a DBA but I thought that oracle would clean up any old sessions/locks after some time? Is there any way to fix this or should I contact a DBA to have a look?
Related Questions in ORACLE9I
- Missing Keyword - Oracle9i
- Merge multiple .dmp files to one.dmp file
- Connect Oracle with PHP
- Using Oracle 9i, how can I extract the first number from a string?
- How can I get data from a stored procedure that contains a Cursor with another Cursor inside it
- Oracle : cannot perform a DML operation inside a query error
- .NET 5 reference from a .NET Framework Oracle 9i Data Access
- Printing data from sub-queries SQL
- How can I retrieve the value of an attribute supported by Oracle?
- Why my program written with Visual studio 2019 cannot read from Oracle 9i database
- PHP Warning: PHP Startup: Unable to load dynamic library 'oci8_12c'
- How to access an Oracle 9.2 *and* Oracle 12c DB with Kotlin running on Java 10+?
- Dealing with quoted string within a where IN clause Oracle 9i
- Oracle group by client and date
- Unable to connect to Oracle 9 (Powerbuilder 12.5) - ORA-12154 error
Related Questions in ROWLOCKING
- SQL Table use as a queue does not work correctly
- How can I exclude reading rows that were selected in the first transaction when executing the second transaction in PostgreSQL?
- Which of the several sessions waiting to acquire an exclusive row lock will be notified first upon release in Oracle RDBMS?
- How to change the value of innodb_lock_wait_timeout from hibernate
- Are there PRECISE RULES to know when MySQL will apply gap blocking?
- BETWEEN SQL - why is there a gap lock?
- when exactly does a lock pseudo-record supremum occur?
- How to enforce 1-[max n] relationship concurrency-safely? Semaphore table?
- row-level locks vs index record locks
- Next-key lock explication - Primary key for range
- InnoDB Locking - Does record lock use indexes?
- MySQL 8.0 (InnoDB) update statement locking more rows than expected, causing deadlocks when called from Tomcat JDBC connection pool
- SELECT FOR UPDATE subquery not respecting LIMIT clause under load
- Select query hangs when a large number of rows have an update lock
- Postgres row locking
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)