In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.