Home » RDBMS Server » Server Administration » Deadlock Occurs (Oracle 9i, Forms 6i)
icon4.gif  Deadlock Occurs [message #358903] Wed, 12 November 2008 22:49 Go to next message
itech
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

oracle 9i, forms 6i

'm facing a deadlock problem whenever i try to use the enterprise manager, and forms 6i together. What's the reasons & solution ?
Re: Deadlock Occurs [message #358945 is a reply to message #358903] Thu, 13 November 2008 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Reasons? Many
Solutions? Depend on the reason.

Each time there is a deadlock a trace file is generated.
Analyze it and the reason of the deadlock you can then fix your application.

Regards
Michel
Re: Deadlock Occurs [message #359020 is a reply to message #358945] Thu, 13 November 2008 05:54 Go to previous messageGo to next message
itech
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

thanks.

some more specific details are as follows

i use to login with same schema at forms 6i, and at Enterprise manager. then i open a form built on that schema n just compiles it (ctrl + k / ctrl + shift + k) , n if i try to perform some ddl on enterprise manager the both application halts.

============
can u please tell where that trace file is located ?

thanking in anticipation.
Re: Deadlock Occurs [message #359023 is a reply to message #359020] Thu, 13 November 2008 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If the application hangs this is not an Oracle deadlock.
In case of deadlock in the instance, Oracle detects it and kill one of the statement, so there is no hang.

User trace files are in the directory given by the parameter "user_dump_dest".

Regards
Michel
Re: Deadlock Occurs [message #359335 is a reply to message #359023] Fri, 14 November 2008 23:12 Go to previous messageGo to next message
itech
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

but when i manually close the form buider the enterprize manager compiles the ddl. else the both hangs.
Re: Deadlock Occurs [message #359344 is a reply to message #359335] Sat, 15 November 2008 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not a deadlock, it is just a wait.
First query v$lock, abd_blockers to know what are the locks.
If no blockers, query v$session_wait or put the sessions in trace mode to know on what they are waiting.

Regards
Michel
Re: Deadlock Occurs [message #359371 is a reply to message #359344] Sat, 15 November 2008 07:01 Go to previous messageGo to next message
itech
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

i check the session & lock tables its dump is attached in the text file bellow

Secondly after some time ORA-04021 was generated "Time out occured while waiting to log object hh.level_d"

This time i was using plsql developer and form 6i
Re: Deadlock Occurs [message #359372 is a reply to message #359371] Sat, 15 November 2008 07:07 Go to previous message
itech
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

Dump for v$session_wait is also attached in this file
Previous Topic: Pmon process in shared server configuration?
Next Topic: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Goto Forum:
  


Current Time: Fri Dec 02 12:12:32 CST 2016

Total time taken to generate the page: 0.13336 seconds