TED]>
Sent by: [EMAIL PROTECTED]
03/24/2003 09:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: AW: Remove killed session from v$session
This is going to remove killed session from v$s
laden" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/24/2003 09:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: AW: Remove killed session from v$session
This is going to remove
of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: AW: Remove killed session from v$session
This is going to remove killed session from v$session:
ps -fu oracle|grep -v PID|awk '{ print $2; }'|xargs kill -9
ipcs -m|grep oracle|awk '{ print $2; }&#
This is going to remove killed session from v$session:
ps -fu oracle|grep -v PID|awk '{ print $2; }'|xargs kill -9
ipcs -m|grep oracle|awk '{ print $2; }'|xargs ipcrm -m
Next time you connect to the database, the killed session will not
be visible in the v$session table.
-Original Message---
lt;[EMAIL PROTECTED]>
cc:
Subject: RE: AW: Remove killed session from v$session
This is going to remove killed session from v$session:
ps -fu oracle|grep -v PID|awk '{ print $2; }'|xargs kill -9
ipcs -m|grep oracle|awk '{ print $2; }'|xargs ipcrm -m
Next ti
Using orakill will not make the rollback happen any faster.
My use of orakill and kill -9 is due to Oracle's sporadic habit
of not cleaning up killed sessions, especially those holding a
lock on a table.
Using orakill won't hurt anything either, but if there is a big
transaction taking place in
Thanks all, the time for the rollback to take place seems to explain why it
takes so long before the session actually disappears from v$session. It's a
development system running long data conversion procedures. Hence, there
will be lots of rollback. ... and I guess I'll opt for orakill then.
Stef
