Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Kill Sniped Connections

Status
Not open for further replies.
Michael42

Michael42

Programmer
Oct 8, 2001
1,454
US
Hello,

In Oracle 9i R2 on Solaris 8 I have a profile that clears connections that are idle after so many minutes. When these connections are cleared however they remain SNIPED until I manually issue the command to kill the connection or the user attempts to use it.

How can I automatically kill SNIPED connections?

Do you know of a script or technique?

Thanks,

Michael42
 
Status
Not open for further replies.

Similar threads

helpdbas
  • Locked
  • Question
kill sessions using loop 1
Replies
13
Views
349
Beilstwh
Beilstwh
helpdbas
  • Locked
  • Question
Transaction still running in a loop after kill immediate
Replies
3
Views
70
SantaMufasa
SantaMufasa
SMS636
  • Locked
  • Question
How to identify session killing application sessions
Replies
0
Views
62
SMS636
SMS636
gatetec
  • Locked
  • Question
kill sessions
Replies
1
Views
60
SantaMufasa
SantaMufasa
ddrillich
  • Locked
  • Question
Closing all connections 3
Replies
19
Views
189
SantaMufasa
SantaMufasa

Part and Inventory Search

Sponsor

Back
Top