OraFAQ Forum: SQL & PL/SQL » Time out error in JAVA application when backend package is calling

Home » SQL & PL/SQL » SQL & PL/SQL » Time out error in JAVA application when backend package is calling

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

Time out error in JAVA application when backend package is calling [message #605892]

Thu, 16 January 2014 00:53

na.dharma@gmail.com
Messages: 82
Registered: May 2008
Location: bangalore

Member

Hi All

From front end when we clicking on save button, we getting the timeout error.

When we clicking on save button, it's calling on backend package.

How do I track/check which part of query is taking so much of time, why because inside of package as so many procedures and queries are called.

Is there any built in table or in TOAD any option to track/check where it's stuck?

Thanks
Dharma

Report message to a moderator

Re: Time out error in JAVA application when backend package is calling [message #605893 is a reply to message #605892]

Thu, 16 January 2014 00:58

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

Senior Member
Account Moderator

You can activate a SQL trace on your session.
You can also use dbms_profiler package.

Report message to a moderator

Re: Time out error in JAVA application when backend package is calling [message #605894 is a reply to message #605892]

Thu, 16 January 2014 01:04

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

Senior Member

From backend join the following views gv$session A,gv$sql B,gv$session_longops to check which sql is running since long. But, to find where the bottleneck is, you need to enable the tracing and then do a thorough analysis of the stats.

Start reading from here

Report message to a moderator

Re: Time out error in JAVA application when backend package is calling [message #605895 is a reply to message #605894]

Thu, 16 January 2014 01:07

na.dharma@gmail.com
Messages: 82
Registered: May 2008
Location: bangalore

Member

How to i check SQL trace is active or not in my database

Report message to a moderator

Re: Time out error in JAVA application when backend package is calling [message #605896 is a reply to message #605895]

Thu, 16 January 2014 01:15

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

Senior Member

na.dharma@gmail.com wrote on Thu, 16 January 2014 12:37

How to i check SQL trace is active or not in my database

You can do it at session level :

SQL> show parameter sql_trace;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sql_trace                            boolean     FALSE

http://docs.oracle.com/cd/B10500_01/server.920/a96533/sqltrace.htm
http://www.orafaq.com/wiki/SQL_Trace

Report message to a moderator

Re: Time out error in JAVA application when backend package is calling [message #605897 is a reply to message #605895]

Thu, 16 January 2014 01:16

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

Senior Member
Account Moderator

na.dharma@gmail.com wrote on Thu, 16 January 2014 08:07

How to i check SQL trace is active or not in my database

It is not.
You have to activate it for YOUR session.
Read Pete Finnigan, How to set trace for others sessions, for your own session and at instance level

Report message to a moderator

Previous Topic:	why would this query return three rows?
Next Topic:	cursor loop

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 05:59:20 CDT 2024