Home » RDBMS Server » Server Administration » Kill a trans
Kill a trans [message #58329] Thu, 14 August 2003 09:15 Go to next message
sidd
Messages: 130
Registered: May 2003
Senior Member
i don't have sys or sysdba privileges how do i kill a transaction in oracle

Report message to a moderator

Re: Kill a trans [message #58345 is a reply to message #58329] Mon, 18 August 2003 00:21 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You need a user with the 'ALTER SYSTEM' privilege.
SQL>Alter system kill session 'SID,SERIAL#'
Where sid and SERIAL# come from the v$session dictionary view.

MHE

Report message to a moderator

Re: Kill a trans [message #58346 is a reply to message #58329] Mon, 18 August 2003 00:51 Go to previous message
Prasad
Messages: 104
Registered: October 2000
Senior Member
If U'r server running on Windows
It would be better using orakill utility, What I generally feel is alter system won't releases resouce held locks unless pmon wakes up in next cycle.So
orakill will does the job.

Usage: orakill sid,thread

On Unix: Use
Kill -9 process_id
Which can be found out using ps -ef

Report message to a moderator

Previous Topic: how can i know the oracle database size
Next Topic: redolog
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 15:28:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.