To find the sid, session id, and the serial#, serial number, run the following query - summarised from OracleBase - and find your session: select s.sid, s.serial#, p.spid, s.username, s.schemaname Oracle level - Kill the process in the databaseĪs per ObiWanKenobi's answer and the ALTER SESSION documentation alter system kill session 'sid,serial#' Most of these are not recommended and can have unintended consequences.ġ. The first one will probably work for you but if it doesn't you can keep moving down the list. The more complicated and the more generic way(s) I detail below in order of increasing ferocity / evil. If so, the easy thing to do is to bash ctrl + break many, many times until it stops. As you keep getting pages of results I'm assuming you started the session in SQL*Plus.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |