Solved

OLEDB Waittype, Status KILLED/ROLLBACK

Posted on 2004-10-14
1
1,088 Views
Last Modified: 2012-06-21
Hello,

I'm having 2 processed that have the Status KILLED/ROLLBACK, after a administrator killed these 2 sessions. The user aborted his application because it was taking to much time before it answered.
These connection where made over a OLEDB to a Oracle Database.

How can i clear/delete these 2 connections, because, even the oracle server is still reachable through the SQL server (in a select ....) the stored procedure that that application was calling/running is even in query analyzer not runnable. If you call that procedure the process hangs too.

Any idea/suggestion ??
0
Comment
Question by:HLEBOEUF
1 Comment
 
LVL 34

Accepted Solution

by:
arbert earned 125 total points
ID: 12315338
You can't.  Unfortunately, there are some transactions that remain (ghost transactions) after they're killed.  They usually don't go away until you restart the server or the SQL Service.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Live Storage Vmotion VMs with shared VMDK 10 57
SQL Replication question 9 42
Sql Server group by 10 27
Connecting to multiple databases to create a Dashboard 5 25
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question