Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to clean Killed Oracle sessions ???
GUYS ,
I got some feedback from some of our friends , But still my problem is
not solved, If anyone knows about this , Please give some suggestions.
Thanks,
Venkata
Roby,
My concern is to get rid of killed process from the database. Even after killing the some of the processes which are inactive and lost client are hanging in the database, So I killed those processes and still I am seeing the killed process , Which are not getting cleaned from the database. We are running oracle 7.3.4 on windows nt. Without shutting down the database is there any way to clean up these killed processed.(i.e Status "Killed").
Thanks,
Venkata
----- Original Message -----
From: Roby Sherman
To: Venkata Jonnala
Sent: Tuesday, May 09, 2000 7:02 PM
Subject: Re: How to clean Killed Oracle sessions ???
If you're running dedicated servers (which under that sort of load
volume I would hope you're not doing) you can kill the session's
corresponding OS process (assuming Unix here) which will immediately
get it out of your hair. If you're running MTS, then the only really
graceful way to get rid of these users is to kill them by the v$session
info (sid, serial#).
Do you know what is causing them to hang out there? Is the session
completing but the process just doesn't seem to go away, or is the
query itself hanging and so you accumulate a number of "hung" sessions?
--Roby
Venkata Jonnala wrote:
Roby, Web based application talking thru JDBC and some of the
background processess got invoked everyt 5 secs and search for anevent
and then they close the session. Please let me know more details.
Thanks a lot for your response, Venkata
----- Original Message -----
From: Roby Sherman
To: Venkata Jonnala
Sent: Tuesday, May 09, 2000 4:58 PM
Subject: Re: How to clean Killed Oracle sessions ???
Hi.
I need a little more detail here... Web based application talking to
the database over MTS or dedicated servers? What is the general
activity performed by the sessions(large updates, small selects, etc.)?
Are the database sessions reused by the web server or is each
connection for a new request?
--Roby
Venkata Jonnala wrote:
Thanks a lot for your response But my problem is this: Web based application and I can't see inactive sessions, I don't have downtime to shutdown and startup to cleanup the killedprocesses. But in the mean time whatever the limit I set for the number of PROCESSES it's reaching the maximum number. Inthis scenario how can I deal with this ???? Please advise me. Thanks,Venkata
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed May 10 2000 - 00:00:00 CDT