Help - Search - Members - Calendar
Full Version: Idle connection
Oracle DBA Forums > Oracle > Oracle Forum
Vugar
What differences between shared server tick and profile idle_time?
aussie_dba
idle_time is inactive time on the server in minutes.

shared server tick is a unit of time in terms of which the connection pool timeout can be specified.

Don't use shared server unless you must, it's sucky.

http://www.dba-oracle.com/t_mts_multithrea...vers_shared.htm
Vugar
QUOTE (Vugar @ Jul 2 2008, 07:56 AM) *
What differences between shared server tick and profile idle_time?


I dont understood, Please help me.Give me example ,
dba@mumbai
Hi ,

The idle_time specify the permitted periods of continuous inactive time during a session, expressed in minutes. Long-running queries and other operations are not subject to this limit.

The same way when we don't do anything and a screen saver starts after specified idle time.

So when a user connects but don't run a query the counting of idle_time starts.


Regards .......
Vugar
QUOTE (Vugar @ Jul 3 2008, 11:49 AM) *
I dont understood, Please help me.Give me example ,



what is tick?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.