Monday, August 27, 2007

New command to kill a session from Oracle SQL+

alter system disconnect session 'sid,serial#' immediate;

I needed that because alter system kill session '<session id>,<serial#>'; doesn't always work.

No comments:

Labels

Blog Archive

The Learner

My photo

a crafty cat who loves food, linux, anime and crafting.

business analyst by day, blogger by night. also a frustrated artist.

Connect