| Session closed automatically [message #555241] |
Tue, 22 May 2012 11:13  |
sathik
Messages: 196
Registered: August 2009
Location: INDIA
|
Senior Member |
|
|
Hi,
One user complained that, his session is closing automatically when his session exceeds exactly 01 hour 1 minute.
default profile is assigned for this user. I checked the idle_time value of this default profile. it is UNLIMITED only.
What else I need to check to find out is there any timeout parameter has been set or not? pls help me.
|
|
|
|
|
|
|
|
|
|
| Re: Session closed automatically [message #555302 is a reply to message #555244] |
Wed, 23 May 2012 02:12  |
sathik
Messages: 196
Registered: August 2009
Location: INDIA
|
Senior Member |
|
|
I have given the required detail below.
SQL> select username,ACCOUNT_STATUS,profile from dba_users where username='WILKINM3';
USERNAME ACCOUNT_STATUS PROFILE
------------------------------ -------------------------------- ------------------------------
WILKINM3 OPEN DEFAULT
SQL> select * from dba_profiles order by PROFILE;
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ------------------------------
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
DEFAULT PRIVATE_SGA KERNEL UNLIMITED
DEFAULT CONNECT_TIME KERNEL UNLIMITED
DEFAULT IDLE_TIME KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
DEFAULT CPU_PER_CALL KERNEL UNLIMITED
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7
LIMITLESS PASSWORD_GRACE_TIME PASSWORD 7
LIMITLESS COMPOSITE_LIMIT KERNEL UNLIMITED
LIMITLESS PASSWORD_REUSE_TIME PASSWORD UNLIMITED
LIMITLESS IDLE_TIME KERNEL UNLIMITED
LIMITLESS PASSWORD_VERIFY_FUNCTION PASSWORD NULL
LIMITLESS LOGICAL_READS_PER_CALL KERNEL UNLIMITED
LIMITLESS PASSWORD_LIFE_TIME PASSWORD UNLIMITED
LIMITLESS LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
LIMITLESS PASSWORD_LOCK_TIME PASSWORD 1
LIMITLESS CPU_PER_CALL KERNEL UNLIMITED
LIMITLESS FAILED_LOGIN_ATTEMPTS PASSWORD 10
LIMITLESS CPU_PER_SESSION KERNEL UNLIMITED
LIMITLESS PASSWORD_REUSE_MAX PASSWORD UNLIMITED
LIMITLESS SESSIONS_PER_USER KERNEL UNLIMITED
LIMITLESS PRIVATE_SGA KERNEL UNLIMITED
LIMITLESS CONNECT_TIME KERNEL 4320 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
