Bismillah
Asalaam Alaikumm Shahid !
The spid column of v$session gives you the shadow process id at Unix o/s.
For e.g.
SQL> SELECT S.USERNAME,S.STATUS, P.SPID,P.PID, S.SID, S.SERIAL#
2 FROM V$PROCESS P, V$SESSION S
3 WHERE P.ADDR=S.PADDR ;
USERNAME STATUS SPID PID SID SERIAL#
------------------------------ -------- --------- ---------- ---------- ----------
ACTIVE 364 2 1 1
ACTIVE 366 3 2 1
ACTIVE 368 4 3 1
ACTIVE 370 5 4 1
ACTIVE 372 6 5 1
ACTIVE 374 7 6 1
ACTIVE 376 8 7 1
TCSS3 ACTIVE 390 9 8 22
TCSS3 ACTIVE 398 10 9 28
9 rows selected.
You can use this SPID to kill the user shadow process
kill -9 <spid>
Best Regards
Your DBA
Salman Faheem
[Email Address Removed] on 06/30/2001 03:31:32 PM
To: "LazyDBA.com Discussion" <[Email Address Removed] unix processes
How to map a unix shadow process (user connection) to a user session via
say threadid
thanks
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
Oracle LazyDBA home page