Hi all,

We have a requirement where we want to check if a user session is valid or not. For this we are doing it as follows :

When a person logs on through our app, we select its session_id as follows :

select dbms_session.unique_Session_id from dual;

We store this in a session table.

Now when admin app needs to chech whether all the entries in the session table are still valid we do it as follows :


Question : This works but sometimes, there is some delay(event 10 min sometimes). Oracle still returns the session as alive even after the app has crashed.

1. Is there a method by which to tune this, so that Oracle detects the dead connections quickly..?
2. Is the method we have chosen above the best way to do it..?

Thanks in advance
Puneet Sachdev