473,508 Members | 2,241 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

killed session

I killed a session on a local database using "alter system kill session"
command. But, in v$session, there is still a recordsed with that session,
marked as killed (db version 9.2.0.1).

How could I really delete this session, because I think it's causing me some
problems?

Also, how could I know which objects (tables, packages) are locked by some
session?

tnx in advance
Jul 19 '05 #1
0 2626

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
4187
by: Rafael Chemtob | last post by:
Hi, I'm using session cookies on my web app and it looks like the session is not being killed when the user closes the browser. We use a Global.asa file on our app. Do we have to explicitly...
4
1896
by: Steve | last post by:
We are using ODP.net (version 9.2.0.4.01) as data provider for Oracle in our dotnet app. Currently we are using Microsoft.NET Framework 1.1 (VS.net IDE 2003) in our project. One thing I feel...
2
6799
by: Steve Foo | last post by:
I have been posting this question in google group, EE, and Oracle OTN forum and still no cannot find a suitable solution for it. I have contacted Singapore Microsoft support regarding the problem...
2
5423
by: Praveen K | last post by:
I have a problem in communicating between the C# and the Excel Interop objects. The problem is something as described below. I use Microsoft Office-XP PIA dll’s as these dll’s were been...
0
1644
by: sql_server_user | last post by:
We're seeing something very strange on our SQL Server 2005 9.0.2047 DB on Windows Server 2003 x64 Standard: 1. Most open connections to the database are being spontaneously terminated by the...
0
382
by: buky | last post by:
I killed a session on a local database using "alter system kill session" command. But, in v$session, there is still a recordsed with that session, marked as killed (db version 9.2.0.1). How...
7
9386
by: dieter | last post by:
Hi, Overview ======= I'm doing some simple file manipulation work and the process gets "Killed" everytime I run it. No traceback, no segfault... just the word "Killed" in the bash shell and...
3
1793
by: sijugeo | last post by:
When I am uploading a file to a folder inside Bin, the session is lost. Why session is lost there? How can we rectify it? Regards, Siju G
0
7225
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7123
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7326
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
5627
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5053
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4707
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3194
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
1
766
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
418
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.