Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Processes with kill status of killed

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

The following is how to go to the kill process when the state of the test session is killed. Today, I saw an official document on MOS. It was written by myself, and the function is similar.

Welcome to join the ORACLE Super Group: 17115662 solve all kinds of ORACLE problems free of charge. BLOG will migrate to http://www.htz.pw in the future.

1, database version

Www.htz.pw > select * from v$version

BANNER

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

PL/SQL Release 11.2.0.4.0-Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0-Production

NLSRTL Version 11.2.0.4.0-Production

2WIN remote login database

D:\ wendang\ SkyDrive\ rs2\ sql > sqlplus scott/oracle@192.168.188.5/orcl1124

SQL*Plus: Release 11.2.0.3.0 Production on Thursday June 5 16:28:36 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL >

3. Manually KILL the session

Www.htz.pw > select sid,serial# from v$session where username='SCOTT'

SID SERIAL#

--

35 51

Www.htz.pw > alter system kill session '35pm 51'

System altered.

4. Check the status of the session

Www.htz.pw > select status,program,server from v$session where username='SCOTT'

STATUS PROGRAM SERVER

-

KILLED sqlplus.exe PSEUDO

Here we can see that SERVER has become pseudo.

Here are the methods before 11G, but here all the processes of D000 are shown.

Www.htz.pw > select spid, program from v$process

2 where programmers = 'PSEUDO'

3 and addr not in (select paddr from v$session)

4 and addr not in (select paddr from v$bgprocess)

5 and addr not in (select paddr from v$shared_server)

SPID PROGRAM

9659 oracle@orcl9i

7095 oracle@orcl9i (D000)

Here is the method of 11G

Www.htz.pw > select 'kill-9' | | spid,program from v$process where addr= (select creator_addr from v$session where status='KILLED')

SPID PROGRAM

9659 oracle@orcl9i

It works better in 11G.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report