Hallo,
I have read so much about this question but could not find an option which we need in our production environment. We have an application which makes frequent queries on production database. We would like to restrict the privileges given to the application and hence have privileged users with restricted profile to make these queries. In real time this application is not at all closed and the number of queries done per day is not fixed.We have only limited number of privileged users to make the query. Now the problem is, since the application is not closed the user is not released even though he query is completed. I mean the session is not closed. I see an entry in V$session as 'SNIPPED'. Since we have only limited number of users, after a specific number of queries the application cannot have login credentials to make the query - i.e. all the users are logged in with snipped sessions and no user available to make query. I read that PMON automatically closes the snipped sessions after sometime. But i tried doing a test in the weekend. Though the query was over by Saturday afternoon the sessions were not closed or killed till Monday morning. I know there is an option to kill the sessions - but that has to be done manually which is not possible in our case - also i doubt whether that closes the session immediately.
Now can anyone help me with a solution to close an Oracle session immediately once the query is over or relieve an user once the purpose is solved.
Thanks in advance.
AGana