OraFAQ Forum: SQL & PL/SQL » Asp.Net Application hangs until oracle package is recompiled

Home » SQL & PL/SQL » SQL & PL/SQL » Asp.Net Application hangs until oracle package is recompiled (Oracle Database 11g Release 11.2.0.1.0 64bit CentOS 6.5)

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

Asp.Net Application hangs until oracle package is recompiled [message #632207]

Tue, 27 January 2015 07:23

praveenpraj
Messages: 21
Registered: October 2011
Location: India

Junior Member

Web application hangs some times while submitting data to oracle through a package procedure.
Hanging used to continue without showing any error.
But when we recompile the package in toad, the application resumes working.
No one was working on the same package at that time. And it was showing as VALID only.

This problem is happening for our two out of four different ASP.NET applications running on different App-Server / DB.

Report message to a moderator

Re: Asp.Net Application hangs until oracle package is recompiled [message #632210 is a reply to message #632207]

Tue, 27 January 2015 07:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

compare & contrast where no error exists against where hang results.
by definition, a difference exists.
only you can discern what is the difference!

Report message to a moderator

Re: Asp.Net Application hangs until oracle package is recompiled [message #632220 is a reply to message #632210]

Tue, 27 January 2015 09:11

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

@OP, how did you come to a concrete conclusion that the reason is invalid objects? Did you look for locks? Do you have any evidence?

Report message to a moderator

Re: Asp.Net Application hangs until oracle package is recompiled [message #635758 is a reply to message #632220]

Wed, 08 April 2015 04:04

praveenpraj
Messages: 21
Registered: October 2011
Location: India

Junior Member

Now one more problem:-
we have two similar asp.net applications having similar database storing data in seperate schemas on same Database server.
Shockingly one of the application shows data from another application's schema.
When we recompiled all the database packages, it got solved.
Tables and most object names are similar in both schemas.
My worry is, is it because of DBA role granted to both ?
And one more thing, Both asp.net applications are hosted on same IIS server.
Please help.

Report message to a moderator

Re: Asp.Net Application hangs until oracle package is recompiled [message #635781 is a reply to message #635758]

Wed, 08 April 2015 07:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Report message to a moderator

Re: Asp.Net Application hangs until oracle package is recompiled [message #635782 is a reply to message #635758]

Wed, 08 April 2015 08:24

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

My worry is, is it because of DBA role granted to both ?

This is surely a problem but most likely not related to your current one.

Report message to a moderator

Re: Asp.Net Application hangs until oracle package is recompiled [message #635784 is a reply to message #635782]

Wed, 08 April 2015 08:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

select owner, object_name, object_type from dba_objects where last_ddl_time > trunc(sysdate-2);

Report message to a moderator

Re: Asp.Net Application hangs until oracle package is recompiled [message #635789 is a reply to message #635758]

Wed, 08 April 2015 09:50

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

praveenpraj wrote on Wed, 08 April 2015 14:34

My worry is, is it because of DBA role granted to both ?

Irrespective of whether this is an issue or not, I think it would be useful for you to read this http://www.orafaq.com/forum/t/164126/0/

Michel has beautifully explained about the DOs and DONTs. Even though it doesn't answer your question, however, you would learn something good about the DBA role.

Report message to a moderator

Re: Asp.Net Application hangs until oracle package is recompiled [message #637455 is a reply to message #635789]

Mon, 18 May 2015 03:40

praveenpraj
Messages: 21
Registered: October 2011
Location: India

Junior Member

Removed the DBA role. May be that was the problem.
Issue didn't appear for last one month.

Thanks to everyone.

Report message to a moderator

Previous Topic:	Procedure creation error - PLS-00103
Next Topic:	regexp_replace comma separated whole string

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 21:53:54 CDT 2024