| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Things to validate / collect before Killing a session !!!!
Perhaps part of the ability may come from the idea that just because the
session has disappeard from v$session does not necessarily mean that the
data dictionary has entirely lost track of the session. This is
conjectural on my part. This is from thee v$fixed_view_definition:
GV$SESSION
select inst_id,addr,indx,ksuseser,ksuudses,ksusepro,
ksuudlui,ksuudlna,ksuudoct,
ksusesow, decode(ksusetrn,hextoraw('00'),null,ksusetrn),
decode(ksqpswat,hextor
aw('00'),null,ksqpswat), decode(bitand(ksuseidl,11),1,'ACTIVE',0,
decode(bitand(
ksuseflg,4096),0,'INACTIVE','CACHED'),2,'SNIPED',3,'SNIPED', 'KILLED'),
decode(k
sspatyp,1,'DEDICATED',2,'SHARED',3,'PSEUDO','NONE'),
ksuudsid,ksuudsna,ksuseunm, ksusepid,ksusemnm,ksusetid,ksusepnm, decode(bitand(ksuseflg,19),17,'BACKGROUND',1,'USER',2,'RECURSIVE','?'), ksusesql, ksusesqh, ksusepsq, ksusepha, ksuseapp, k
VIEW_NAME
Note the use of ksuseflg in both the select list for decoding status and it's use in the where clause to qualify the rows for the view. Now once again this is conjectural, but it seems possible that a killed row's session might remain in x$ksuse and hence available to pmon but not to v$session based on the value of this flag. BTW this is from an 8.1.7.4 instance.
Allan
-----Original Message-----
Sent: Wednesday, April 09, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L
According to the Oracle docs...
PMON will do the job! it will rollback the transaction!
HTH
> And also are there any parameters in init.ora that
> are going to effect the Rollback ( Any Parallel
> Rollback ??? ).
>
>
>
> [Madhu, Reddy]
>
> -----Original Message-----
> Sent: Tuesday, April 08, 2003 3:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Madhu.
>
> You seem to be confused between "kill -9" and "Alter
> system" and adding to the confusion.."rollback" and "PARALLEL"
>
> I suggest read the Concepts manual, epc on how
> client and server process work for an oracle
> session.
>
> -Arun.
> Sr. Oracle DBA
>
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L
> <mailto:ORACLE-L_at_fatcity.com>
> Sent: Friday, April 04, 2003 2:53 PM
>
>
>
> Thanks Kurt !!!
>
> All,
>
> what Actually Oracle will do when we kill the JOB by
> " kill -9" , instead of "Alter System ....". What
> about the Rollback ??
> Any PARALLEL parameters in init.ora has any effect
> if we kill the process by "kill -9".
>
>
>
> Any other inputs on " Collecting the stats before
> killing a session " ??
>
> [Madhu, Reddy]
>
> -----Original Message-----
> Sent: Friday, April 04, 2003 11:24 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> I always check to see how much rollback they have in
> case I want to watch
> it rollback and I always make sure I get the pid for
> the associated UNIX
> process in case I decide I need to kill it. Of
> course, I always almost
> remember to do these two things.
>
> Kurt
>
> -----Original Message-----
> Sent: Friday, April 04, 2003 11:34 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi List,
> We all need to kill the user sessions in the
> situations of locking or sometime on end user /
> application support person's request . I would like
> to know best practices followed before killing a
> session , Any of you collect some
> information/statistics before kill ??
>
> Please share your ideas and advice me on this.
>
> Thanks in advance,Madhu
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Reddy, Madhusudana
> INET: Madhusudana.Reddy_at_bestbuy.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: joseluis_delgado_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). ______________________________________________________________________________ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: anelson_at_midf.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).Received on Wed Apr 09 2003 - 13:19:56 CDT
 |
 |