OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Deadlock Occurs (Oracle 9i, Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Deadlock Occurs [message #358903]

Wed, 12 November 2008 22:49

itech
Messages: 173
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 ?

Report message to a moderator

Re: Deadlock Occurs [message #358945 is a reply to message #358903]

Thu, 13 November 2008 00:56

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: Deadlock Occurs [message #359020 is a reply to message #358945]

Thu, 13 November 2008 05:54

itech
Messages: 173
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.

Report message to a moderator

Re: Deadlock Occurs [message #359023 is a reply to message #359020]

Thu, 13 November 2008 06:05

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: Deadlock Occurs [message #359335 is a reply to message #359023]

Fri, 14 November 2008 23:12

itech
Messages: 173
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.

Report message to a moderator

Re: Deadlock Occurs [message #359344 is a reply to message #359335]

Sat, 15 November 2008 01:14

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: Deadlock Occurs [message #359371 is a reply to message #359344]

Sat, 15 November 2008 07:01

itech
Messages: 173
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

Attachment: v$session_v$lock.txt
(Size: 5.40KB, Downloaded 1038 times)

Report message to a moderator

Re: Deadlock Occurs [message #359372 is a reply to message #359371]

Sat, 15 November 2008 07:07

itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan

Senior Member

Dump for v$session_wait is also attached in this file

Attachment: v$session_wait.txt
(Size: 1.44KB, Downloaded 1091 times)

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 11:43:00 CDT 2024