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
Messages: 74
Registered: November 2007
Location: mumbai
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.?

Re: Switch Time [message #353273 is a reply to message #353272] Mon, 13 October 2008 03:19 Go to previous message
Michel Cadot
Messages: 63923
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"

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

Current Time: Tue Oct 25 14:51:54 CDT 2016

Total time taken to generate the page: 0.17393 seconds