What is the vlaue of DEFAULT in dba_profile
BipulJan 30 2009 — edited Jan 30 2009We are facing a problem on IDLE_TIME when application dodn't use the DB for long time:
While connecting to Database through Web code we are getting the following error :
java.sql.SQLException: ORA-02396: exceeded maximum idle time, please connect again
java.sql.SQLException: ORA-01012: not logged on
We are only facing this problem after weekend, means the connection becoming Idle since no one use it during weekend.
All application user belongs to Profile 'VIEW_PROFILE'.
SQL> select * from dba_profiles where PROFILE ='VIEW_PROFILE';
PROFILE RESOURCE_NAME RESOURCE LIMIT
-----
VIEW_PROFILE COMPOSITE_LIMIT KERNEL DEFAULT
VIEW_PROFILE SESSIONS_PER_USER KERNEL 225
VIEW_PROFILE CPU_PER_SESSION KERNEL DEFAULT
VIEW_PROFILE CPU_PER_CALL KERNEL DEFAULT
VIEW_PROFILE LOGICAL_READS_PER_SESSION KERNEL DEFAULT
VIEW_PROFILE LOGICAL_READS_PER_CALL KERNEL DEFAULT
VIEW_PROFILE IDLE_TIME KERNEL DEFAULT
VIEW_PROFILE CONNECT_TIME KERNEL DEFAULT
VIEW_PROFILE PRIVATE_SGA KERNEL DEFAULT
VIEW_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD 9999
VIEW_PROFILE PASSWORD_LIFE_TIME PASSWORD DEFAULT
VIEW_PROFILE PASSWORD_REUSE_TIME PASSWORD DEFAULT
VIEW_PROFILE PASSWORD_REUSE_MAX PASSWORD DEFAULT
VIEW_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD DEFAULT
VIEW_PROFILE PASSWORD_LOCK_TIME PASSWORD DEFAULT
VIEW_PROFILE PASSWORD_GRACE_TIME PASSWORD DEFAULT
16 rows selected.
Before changing it to Unlimited , I want to know In dba_profiles - what is the actual value for DFAULT in oracle 8.1.7.4.0 ?
There must be some value associated with DEFAULT, does anyone knows that ?