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?
Oracle 9i database - ORA-00054 RESOURCE BUSY
248 Views Asked by Louise At
0
There are 0 best solutions below
Related Questions in ORACLE9I
- Logging dml operation without trigger
- Get all LCR for table
- ORA-01461 Exception During Bulk Insert
- Toad development suite installation 9.7.2 commercial time taken?
- ORA-00933: SQL command not properly ended in oracle
- How to get all database names in oracle using c#?
- Convert multiple rows into 1 column without pivot in oracle
- What is the query to display all database in oracle server 9i?
- Convert columns to rows in oracle 9i
- Substring between characters in Oracle 9i
- SQL Statement - Query a set of records with the most recent date
- Updating board in oracle form
- Insert select continue with error
- How to avoid DIVIDE BY ZERO error in an SQL query
- How to check if a table exist in Oracle?
Related Questions in ROWLOCKING
- select for update in stored procedure (concurrently increment a field)
- How to totally lock a row in Entity Framework
- Rowlock and lock escalation
- oracle row contention causing deadlock errors in high throughtput JMS application
- Do I need UPDLOCK hint in this SP? Reading a Data Queue Row More Than Once
- Unit-testing PostgreSQL row-level locks
- Oracle 9i database - ORA-00054 RESOURCE BUSY
- (my)SQL Row Lock while user enters data c#
- Test lock status of rows in MySQL/InnoDB
- I need row-level locking
- Pessimistic locking of record?
- How can I force MySQL to obtain a table-lock for a transaction?
- Ensuring unique numbers from a sql server database
- sql server compact deadlock caused by page-lock on index
- sql server hint NOLOCK and ROWLOCK
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)
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?