Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Profile and idle_time

Profile and idle_time

From: <G.Plivna_at_itsystems.lv>
Date: Fri, 9 Jun 2000 15:50:54 +0300
Message-Id: <10523.108393@fatcity.com>


Hi, all!

I created profile and set parameter idle_time = 5 As explained by Oracle docs idle_time "limits periods of continuous inactive time during a session, expressed in minutes" Assigned this profile to a user.
Unfortunately it seems user exceeds their limit just after 1-2 minutes.

Any suggestions, solutions?

Gints Plivna

P.S. Here are data

SQL> select * from dba_profiles where profile='LIMITED' order by resource_name;

PROFILE                        RESOURCE_NAME                    RESOURCE
LIMIT
------------------------------ -------------------------------- --------

LIMITED                        COMPOSITE_LIMIT                  KERNEL
DEFAULT
LIMITED                        CONNECT_TIME                     KERNEL
DEFAULT
LIMITED                        CPU_PER_CALL                     KERNEL
DEFAULT
LIMITED                        CPU_PER_SESSION                  KERNEL
DEFAULT
LIMITED                        FAILED_LOGIN_ATTEMPTS            PASSWORD
DEFAULT
LIMITED                        IDLE_TIME                        KERNEL   5
LIMITED                        LOGICAL_READS_PER_CALL           KERNEL
DEFAULT
LIMITED                        LOGICAL_READS_PER_SESSION        KERNEL
DEFAULT
LIMITED                        PASSWORD_GRACE_TIME              PASSWORD
DEFAULT
LIMITED                        PASSWORD_LIFE_TIME               PASSWORD
DEFAULT
LIMITED                        PASSWORD_LOCK_TIME               PASSWORD
DEFAULT
LIMITED                        PASSWORD_REUSE_MAX               PASSWORD
DEFAULT
LIMITED                        PASSWORD_REUSE_TIME              PASSWORD
DEFAULT
LIMITED                        PASSWORD_VERIFY_FUNCTION         PASSWORD
DEFAULT
LIMITED                        PRIVATE_SGA                      KERNEL
DEFAULT
LIMITED                        SESSIONS_PER_USER                KERNEL
DEFAULT 16 rows selected.

SQL> select username from dba_users where profile = 'LIMITED';

USERNAME



ARVIS 15:43:46 SQL> select user from dual;

USER



ARVIS 15:44:02 SQL> select user from dual; Received on Fri Jun 09 2000 - 07:50:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US