Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Production database got hanged

poornaFeb 3 2011 — edited Feb 3 2011
Hi,

Oracle Version:10.2.0.3
Operating System:Linux

One of our production database got hanged hanged and stop responding when we tried to find any locks are there through putty that statement got hanged for more than 1hr and it through error .
oracle@virqts2ora001{Primary}:qfundeca:/home/oracle
$ !sq
sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 3 04:51:12 2011

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Release 10.2.0.3.0 - Production

SQL> select * from v$locked_object;
select * from v$locked_object
*
ERROR at line 1:
ORA-44203: timeout waiting for lock on cursor
Please help me what to do if we got this error and nothing is written in alert log file and generating so many trace files in udump location.

Thanks & Regards,
Poorna Prasad.S

Comments

oradba
ORA-44203: timeout waiting for lock on cursor
Cause: A timeout occured while waiting for a cursor to be compiled. This is
usually caused by the SQL parse requiring access to system resources which are
locked by concurrently executing sessions.
Action: Investigate possible causes of resource contention. If neccessary, contact
support for additional information on how to diagnose this problem.

------------------

I guess you have to follow the last sentence.

Werner
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 3 2011
Added on Feb 3 2011
#general-database-discussions
1 comment
332 views