DBA Hub

📋Steps in this guide1/1

Kill snipped session in db

It will generate kill session statements for all snipped sessions:

oracle configurationintermediate
by OracleDba
12 views
1

Kill snipped session in db

Code/Command (click line numbers to comment):

1
2
It will generate kill session statements for all snipped sessions:
select 'alter system kill session '''||sid||','||serial#||''' immediate;' from v$session where status='SNIPED' ;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!