Home » SQL & PL/SQL » SQL & PL/SQL » Switch Time (Win XP, Oracle 10g)
Switch Time [message #353272] Mon, 13 October 2008 02:45 Go to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
Hi All,


I have an issue, I am frequently getting error Not Logged on!,
I beleive connection is getting timed out,
can anybody please suggest how can we know Switch Time for any ID?
that is for how long connection will sustain before it will
be aborted.?


thanks,
abhi
Re: Switch Time [message #353273 is a reply to message #353272] Mon, 13 October 2008 03:19 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not an Oracle error.
Each user can be associated to a profile which can define a maximum idle time but the error code you can get is:
ORA-02396: "exceeded maximum idle time, please connect again"

Of course, if you ignore this error and retry to execute something you get:
ORA-01012: "not logged on"


Regards
Michel
Previous Topic: DECODE QUERY
Next Topic: SEQUENCE
Goto Forum:
  


Current Time: Thu Dec 08 16:20:47 CST 2016

Total time taken to generate the page: 0.11276 seconds