When the application which is built on D2k is kept idle for 10mts, The session gets diconnected. Can any one help?
Check the privilege associated with that user and check the idle time associated with the privilege
A Winner never Quits, A Quitter never Wins
How to check the idle time associated with role ?
Try this following query as SYSTEM:
SELECT a.username, b.resource_name,
FROM dba_users a, dba_profiles b
WHERE a.profile = b.profile AND
a.username = 'SCOTT'
See what profile does the user has .
in dba_user see what profile the user has.
in the dba_profiles see the value for idle_time ..
incase if it is low increase the time to your reqiurements..
Click Here to Expand Forum to Full Width