This content has been marked as final. Show 4 replies
Hi Prema,1 person found this helpful
I think you can kill user session ffrom backend. Below URl may helps you
Hope it will helps you
If you want to kill ODI execution session( I mean like user executed any scenario or package or interface or procedure from ODI), go to Operator >right click on execution session > click stop normal or stop immediate
Thanks for your reply.
However, I am not able to see the gv$session table in the database.
Thanks & Regards,
The user you are logging in as will need to either have sys privileges, or have been granted select privileges on the view and underlying tables.
gv$session is for a RAC database , if you are running a single node then it will be v$session.
As Phil says - Check you have valid permissions to view it.