Database Administration (MOSC)

MOSC Banner

Killed sessions not cleaned up

edited Apr 11, 2012 8:06PM in Database Administration (MOSC) 1 commentAnswered
Hi,

I killed few user sessions , Oracle show the session status as 'Killed' and never release those processes. I can't see session process id (spid) if I run the query against v$session and v$process. Whats going on here? could somebody explain ?

Bouncing database is not an option for me to clean held up processes and kinda resources are limited on these box so some how I need to clean these processes. How ?

Version:9.2.0.6

 

SQL> sho parameter processes;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     2
job_queue_processes                  integer     2
log_archive_max_processes            integer     2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center