Message-Id: <10752.127561@fatcity.com> From: Jacques Kilchoer Date: Thu, 25 Jan 2001 18:54:01 -0800 Subject: RE: timeout setting. 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@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 RE: timeout setting.

> -----Original Message-----
> From: Ajay Khandelwal [mailto:ajay@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