473,657 Members | 2,571 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Oracle Exceeded maximum idle time

re: Oracle Exceeded maximum idle time

I have asp.net web gridview that is populated by a function that calls
an Oracle procedure that returns a dataset. At most, it might take 2
or 4 seconds to come back on average. However, somtimes I get this
error.

ORA-02396: exceeded maximum idle time, please connect again

Where should i adjust my the timeout?

In the connection string?
in the ADO.net oracle command? currently set to 0, not sure what that
means exactly.

.CommandTimeout = 0

in IIS? or Oracle?
Also on a related note. I am always sure to close all my connections.
But I noticed even when I know for sure the process did not fail and I
closed the Oracle connection in my code that two Idle Oracle sessions
seem to hang around idle until the system kills them with this wierd
SQL text behind them:

ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA'
NLS_CURRENCY= '$' NLS_ISO_CURRENC Y= 'AMERICA' NLS_NUMERIC_CHA RACTERS=
'.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT = 'DD-MON-RR'
NLS_DATE_LANGUA GE= 'AMERICAN' NLS_SORT= 'BINARY' TIME_ZONE= '-05:00'
NLS_COMP= 'BINARY' NLS_DUAL_CURREN CY= '$' NLS_TIME_FORMAT =
'HH.MI.SSXFF AM' NLS_TIMESTAMP_F ORMAT= 'DD-MON-RR HH.MI.SSXFF AM'
NLS_TIME_TZ_FOR MAT= 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_T Z_FORMAT= 'DD-
MON-RR HH.MI.SSXFF AM TZR'

Is there something I need to tweak somewhere? A setting in the
connection?
Nov 16 '07 #1
0 3230

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2917
by: John | last post by:
I am trying to create thumbnails from 2500 pictures. But I always get a Maximum execution time of 30 seconds exceeded" at the statement with the method with imagejpeg or imagedestroy after processing and creating 500 thumbnails. Is there anything I can do to avoid this error? Thank you John
1
4298
by: buky | last post by:
How can I find and set an idle time when oracle database releases some objects (tables, etc.) or opened sessions?
1
3990
by: Dave Smithz | last post by:
Hi, My PHP application for a client uses the publicly available "PHPMailer - PHP email class" which is very good. However, my client recently complained about the following error when sending out over 4000 emails. (Note that each email is customised so needs to be sent individually - not using Bcc). The application reported to have sent the 4000 emails successfully (it sends each one as part of a loop and then when completed gives a...
2
1649
by: ivancasher | last post by:
I´ve this warning in a php page "Maximum execution time of 30 seconds exceeded ", I´ve configurated the php.in, setting the value of max_execution_time = 1200, and then i restart the apache service. The apache server is in a Win2000 server machine. Thank´s
9
5007
by: Shuan | last post by:
I am getting this error. Can it be fixed by setting more than 60 for the max_execution_time in php.in file? Fatal error: Maximum execution time of 60 seconds exceeded in categorycrawler.php on line 19 on this line i have regular expression preg_match_all(,,)
33
7416
by: ram.ragu | last post by:
hi i have problem to calculate idle time of cpu and if idle time is more then i have to shut down the system. can anyone tell me the idea to so that please
1
3779
by: jobs | last post by:
I got this error while performing an ado.net call to an oracle procedure that returns a dataset. Exception of type 'System.Web.HttpUnhandledException' was thrown.ORA-02396: exceeded maximum idle time, please connect again System.WebSystem.Exception The process maybe takes 2 to 3 seconds to come back to the webpage. my vb.net method has cmd.timeout=0
2
3038
by: Richard | last post by:
Hello all, I am looking into issues with time-outs on a website. These appear to happen in a random way for some users. This is one example: Fatal error: Maximum execution time of 60 seconds exceeded in auth.php on line 5 auth.php contains:
3
3728
by: agarwalsunitadhn | last post by:
Hi I have a problem that whenever i fetch a large amount of data from database then it shows the following error with a part of result: Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\fps\report7.php on line 95. and refreshing that page . we got the complete data. If you have any suggestion that how to fetch complete data at a time then please .. thanks
0
8305
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8823
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8730
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8605
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7321
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6163
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4301
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1607
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.