RE: timeout setting.

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 25 Jan 2001 18:54:01 -0800
Message-Id: <10752.127561@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C08743.3CD2A410
Content-Type: text/plain;

charset="iso-8859-1"

> -----Original Message-----
> From: Ajay Khandelwal [mailto:ajay_at_tems.com]
> Sent: jeudi, 25. janvier 2001 13:59
> 
> Is there any way I can set time out for a user session.

Option 1: Take a look at the Net8 Administrator guide. There is a a paramer in the sqlnet.ora file called "sqlnet.expire_time" that "determines time interval to send a probe to verify the session is alive".

Option 2: In the Oracle 8 Administrator's guide, you should read chapter 23: Managing Users and Resources, and in the SQL Reference manual, the description of the Create Profile command. You create a profile and assign the profile to a user with the alter user command. An example of some of the items you can set in a profile (copied from the SQL Reference Manual) CPU_PER_SESSION - limits the CPU time for a session, expressed in hundredth of seconds.
CPU_PER_CALL - limits the CPU time for a call (a parse, execute, or fetch), expressed in hundredths of seconds.
CONNECT_TIME - limits the total elapsed time of a session, expressed in minutes.
IDLE_TIME - limits periods of continuous inactive time during a session, expressed in minutes. Long-running queries and other operations are not subject to this limit.

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

------_=_NextPart_001_01C08743.3CD2A410
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: timeout setting.</TITLE>
</HEAD>
<BODY>

> -----Original Message-----
 > From: Ajay Khandelwal [<A =
HREF=3D"mailto:ajay_at_tems.com">mailto:ajay_at_tems.com</A>]
 > Sent: jeudi, 25. janvier 2001 13:59
 > 
 > Is there any way I can set time out for a user =
session.


Option 1: Take a look at the Net8 Administrator =
guide. There is a a paramer in the sqlnet.ora file called = "sqlnet.expire_time" that "determines time interval to = send a probe to verify the session is alive".

Option 2: In the Oracle 8 Administrator's guide, you =
should read chapter 23: Managing Users and Resources, and in the SQL = Reference manual, the description of the Create Profile command. You = create a profile and assign the profile to a user with the alter user = command. An example of some of the items you can set in a profile = (copied from the SQL Reference Manual)

CPU_PER_SESSION - limits the CPU time for a session, =
expressed in hundredth of seconds.  
 CPU_PER_CALL - limits the CPU time for a call (a =
parse, execute, or fetch), expressed in hundredths of seconds.  =

 CONNECT_TIME - limits the total elapsed time of a =
session, expressed in minutes.  
 IDLE_TIME - limits periods of continuous inactive =
time during a session, expressed in minutes. Long-running queries and = other operations are not subject to this limit.

------
 any ignorant comments made are the sole =
responsibility of J. R. Kilchoer and should not reflect adversely upon = my employer.

 
 Jacques R. Kilchoer
 (949) 754-8816
 Quest Software, Inc.
 8001 Irvine Center Drive
 Irvine, California 92618
 U.S.A.
 <A HREF=3D"http://www.quest.com" =
TARGET=3D"_blank">http://www.quest.com</A> Received on Thu Jan 25 2001 - 20:54:01 CST