| dblink sequence problem [message #114696] |
Tue, 05 April 2005 02:25  |
_simma_dba
Messages: 34
Registered: November 2003
|
Member |
|
|
Here is the situation:
I have dblink on some db that is in other town, and procedure that use that dblink. In that procedure I have SELECT SEQUENCE@DBLINK FROM DUAL, (selecting some sequence from remote db).At the moment of my selection, the remote database went down (administrator on that location used SHUTDOWN ABORT  ). My session was blocked and I cant kill it. As I can see session waits for selection of that sequence, and I dont know how to kill it.
Help pls
|
|
|
|
|
|
| Re: dblink sequence problem [message #114858 is a reply to message #114696] |
Tue, 05 April 2005 20:13  |
win_vj
Messages: 16
Registered: March 2005
Location: India
|
Junior Member |
|
|
Follow the steps given below.
1. SELECT s.sid,s.serial#,s.osuser,s.program FROM v$session s;
2. Identify your sid and serial# and then
ALTER SYSTEM KILL SESSION 'sid,serial#';
But the thing is you must have the permissions to kill the session.
Vijay
|
|
|
|
| Re: dblink sequence problem [message #114886 is a reply to message #114858] |
Wed, 06 April 2005 01:58 |
_simma_dba
Messages: 34
Registered: November 2003
|
Member |
|
|
|
Yes I told u that I cant kill my that session. I try this, but only thing that I get is "session marked for kill". Session has status killed but nothing happens for 3 days allredy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
