Re: How to limit session

From: godmann <allanwtham_at_yahoo.com>
Date: 24 Oct 2001 19:56:34 -0700
Message-ID: <95cd51c.0110241856.5cfead22@posting.google.com>

Hi there,

The status column of v$session actually means no ACTIVE SQL STATEMENT being executed at that particular moment. However, the users are logon. If you want, you can create user profile whereby a user who logon without doing anything will be log off as specified by the parameter IDLE_TIME. You can also limit total session per user using the parameter SESSIONS_PER_USER.

Allan W. Tham
DBA Received on Wed Oct 24 2001 - 21:56:34 CDT