Home » RDBMS Server » Server Administration » session still KILLED in oracle, process don´t exist in SO (oracle, 10.2.0.3.0, SunOS 5.8)
session still KILLED in oracle, process don´t exist in SO [message #354998] Wed, 22 October 2008 03:05 Go to next message
ciri
Messages: 11
Registered: October 2008
Junior Member
Hello

Some days ago I run a java object in an sqlplus instance, but it didn´t work properly, and the object didn´t finish, so I finished the execution by CTL+D. After that, I noticed that the object was locked. I saw in v$session view that there was still an active session for that execution, so i tried alter system kill session immediate. The session then turned to KILLED. I also noticed that the process didn´t exist in my OS. Today, the session still remains as KILLED.

What i should do to get the session dissapeared, and get the object unlocked?

Thanks in advance.

Report message to a moderator

Re: session still KILLED in oracle, process don´t exist in SO [message #355931 is a reply to message #354998] Tue, 28 October 2008 10:48 Go to previous message
ciri
Messages: 11
Registered: October 2008
Junior Member
Hi,

Finally, I had to shutdown the database and start it.

Report message to a moderator

Previous Topic: Database Dismounting takes much time
Next Topic: Performance tuning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 00:26:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.