Home » RDBMS Server » Performance Tuning » regarding session time out
regarding session time out [message #427516] Fri, 23 October 2009 01:03 Go to next message
karthikeyanc2003
Messages: 33
Registered: August 2009
Location: india
Member
hi folks,
i have a procedure which has a update query of a table contain large volume say 10 million and it will take around 10 hours , but the problem is that when i run the sp it got the session time out error after six or seven hours becsuse of that whole sp fails how to retifi it how to extend the session timeout time

Report message to a moderator

Re: regarding session time out [message #427519 is a reply to message #427516] Fri, 23 October 2009 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no Oracle session time-out.
However it is possible to limit the duration of a session or a call using PROFILE. Check your profile.

ALWAYS post the full and exact error message.

Regards
Michel

Report message to a moderator

Re: regarding session time out [message #427528 is a reply to message #427516] Fri, 23 October 2009 02:03 Go to previous messageGo to next message
karthikeyanc2003
Messages: 33
Registered: August 2009
Location: india
Member
hi Michle ,
Thanks for your reply , but let me know how can i slove the session timeout problem while running a query , i use the sql plus only for the process.

Report message to a moderator

Re: regarding session time out [message #427531 is a reply to message #427528] Fri, 23 October 2009 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ALWAYS post the full and exact error message.

Without this I can't even know from what the error comes from and so how to solve it.

Regards
Michel

Report message to a moderator

Re: regarding session time out [message #427534 is a reply to message #427531] Fri, 23 October 2009 03:07 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
it is possible to limit the duration of a session or a call using PROFILE. Check your profile.


Post exactly what you get while running the query. If not DO the above mentioned by michel.

Report message to a moderator

Previous Topic: How to view Oracle counters in windows performance monitor
Next Topic: Optimizing the query containing 7 table joins
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 21 20:54:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.