Skip to Main Content

Oracle Database Discussions

How to abort specific user sessions in RAC and stop the user to connect again to DB.

User_SZR3UAug 25 2022

Hi,
We need to abort specific user sessions every night at 23:00 and stop the user to connect to the DB. Then allow the user to connect to the DB next day at 8:00.
I am new in Oracle. I only know I can kill user session by
alter system kill session 'SID,SERIAL#,@INST_ID' immediate;
But the problem is, KILL SESSION sometimes only mark a session as terminated and roll back ongoing transactions. It does not actually abort the transactions.
Is it possible to KILL SESSION something like abort all their transactions (we allow data loss for this user) ? And is there any way we can restrict the user to connect to DB?
Thank you very much

Comments
Post Details
Added on Aug 25 2022
9 comments
169 views