Dynamic sql script to kill over 500 sessions

[davey23uk]

Hi
Can anyone provide me with a dynamic sql script to kill more than 500 sessions
Thanks

shutdown abort will do that for you

anyway, the script depends on what you want to kill

loop through v$session, pull out the sid and serial then kill it