IRC, evn with MTS, a busy session should have the PID of the shared server
associated with it in v$process, and only one session at a time can use
the
shared server.
Killing it should effect only the session using the SS at that time, and
MTS
should spawn another.
Nonetheless, I don't recommend doing it. :)
Jared
"Sherman, Paul R." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/16/2002 09:04 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: How do I check whether a rollback activity is going on
Jared,
I agree with you, except for when MTS is being used.
Thank you,
Paul Sherman
DBA Elcom, Inc.
voice - 781-501-4143 (direct #)
fax - 781-278-8341 (secure)
email - [EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, July 15, 2002 8:38 PM
To: Multiple recipients of list ORACLE-L
It could be that pmon is rolling back the transaction.
It could also be that pmon is never going to clean it up, which sometimes
happens when killing an active transaction.
I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on
Unix to kill the process, rather than killing the session in Oracle.
If your session has still not been cleaned up, you'll understand my
position, as you will now have to bounce your database.
Check to see if the session is holding a lock, if so, and an unreasonable
amount of time has passed for pmon to do its cleanup, then you likely
need to bounce the database.
Jared
Gurelei <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/15/2002 02:39 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject: How do I check whether a rollback activity is
going
on
Hi.
Here is my situation. I have killed an ORacle
transaction. Oracle came back with "session marked for
kill" and the status of the session is now "Killed".
I presume that the reason is that Oracle needs to roll
back the changes made. Can I confirm whether this is
indeed the case via some system tables?
thakns
gene
__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gurelei
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Paul R.
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
