Session gets disconnected

[johndhin]

When the application which is built on D2k is kept idle for 10mts, The session gets diconnected. Can any one help?

[aarganesh]

Check the privilege associated with that user and check the idle time associated with the privilege
Rgds
Ganesh .R

[johndhin]

hi ganesh

How to check the idle time associated with role ?

[rpardip]

Try this following query as SYSTEM:


SELECT a.username, b.resource_name,
b.resource_type, b.limit
FROM dba_users a, dba_profiles b
WHERE a.profile = b.profile AND
a.username = 'SCOTT'

[omegamark]

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..