Is it possible to kill a session at the Database layer? Will the Siebel session be terminated?
he session can be killed at the Database layer, however the Siebel object manager's DB Connector will automatically perform a session reconnect :
Here is the session from Oracle's v$session table :
The columns are; logon_time, username, sid, serial#, osuser, program, process
02/26/2014 22:29:30 SADMIN 54 173 NT AUTHORITY\SYSTEM siebmtshmw.exe 5496:6032
Kill this session :
SQL> alter system kill session '54,173,@1' immediate;
System altered.