12c进入pdb后，查询v$session仅显示当前pdb的连接session信息

最新推荐文章于 2023-07-13 11:35:43 发布

原创最新推荐文章于 2023-07-13 11:35:43 发布 · 2.1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#12c pdb v$session

Oracle 专栏收录该内容

120 篇文章

订阅专栏

在Oracle 12c环境中，当进入一个PDB（Pluggable Database）后，通过v$session查询只会显示该PDB内的会话信息。例如，使用PLSQL Developer分别连接到ORCL1PDB1和ORCL1PDB2，然后在sysdba模式下切换到ORCL1PDB2，v$session将只显示ORCL1PDB2的相关进程。示例中展示了如何查看和操作这些进程。

[oracle@ora12c1 ~]$ ps -ef |grep LOCAL=NO
oracle 625 1 1 11:05 ? 00:00:01 oracleorcl11 (LOCAL=NO) -->使用PLSQL DEVELOPER1连接orcl1pdb1
oracle 946 1 2 11:07 ? 00:00:00 oracleorcl11 (LOCAL=NO) -->使用PLSQL DEVELOPER2连接orcl1pdb2
oracle 996 32059 0 11:07 pts/2 00:00:00 grep --color=auto LOCAL=NO
[oracle@ora12c1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Thu Mar 22 11:08:41 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> alter session set container=ORCL1PDB2;
Session altered.
SQL> select 'kill -9'||''||' '||p.spid||'' from v$process p,v$session s where s.paddr=p.addr;
'KILL-9'||''||''||P.SPID||''
--------------------------------
kill -9 12929
kill -9 12931
kill -9 12933
kill -9 12935
kill -9 12937
kill -9 12941
kill -9 12943
kill -9 13011
kill -9 12947
kill -9 12947
kill -9 12952
kill -9 12954
kill -9 12954
kill -9 12958
kill -9 12960
kill -9 12962
kill -9 12964
kill -9 12966
kill -9 12968
kill -9 12970
kill -9 12972
kill -9 12974
kill -9 12976
kill -9 12979
kill -9 12982
kill -9 12984
kill -9 12987
kill -9 12989
kill -9 12991
kill -9 12993
kill -9 12995
kill -9 12997
kill -9 30369
kill -9 13001
kill -9 13005
kill -9 13007
kill -9 13009
kill -9 13013
kill -9 13015
kill -9 13017
kill -9 13023
kill -9 13025
kill -9 13029
kill -9 13032
kill -9 13034
kill -9 13036
kill -9 18827
kill -9 13048
kill -9 13063
kill -9 784
kill -9 13276
kill -9 13324
kill -9 13326
kill -9 13328
kill -9 13330
kill -9 13332
kill -9 13334
kill -9 13336
kill -9 13360
kill -9 13486
kill -9 13489
kill -9 13522
kill -9 13560
kill -9 13562
kill -9 13564
kill -9 13723
kill -9 6719
kill -9 529
kill -9 13687
kill -9 19050
kill -9 19830
kill -9 561
kill -9 946 ------>pid 946进程
kill -9 1037
kill -9 1243
75 rows selected.

SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 ORCL1PDB1 READ WRITE NO
SQL> select 'kill -9'||''||' '||p.spid||'' from v$process p,v$session s where s.paddr=p.addr;
'KILL-9'||''||''||P.SPID||''
--------------------------------
kill -9 12929
kill -9 12931
kill -9 12933
kill -9 12935
kill -9 12937
kill -9 12941
kill -9 12943
kill -9 13011
kill -9 12947
kill -9 12947
kill -9 12952
kill -9 12954
kill -9 12954
kill -9 12958
kill -9 12960
kill -9 12962
kill -9 12964
kill -9 12966
kill -9 12968
kill -9 12970
kill -9 12972
kill -9 12974
kill -9 12976
kill -9 12979
kill -9 12982
kill -9 12984
kill -9 12987
kill -9 12989
kill -9 12991
kill -9 12993
kill -9 12995
kill -9 12997
kill -9 30369
kill -9 13001
kill -9 31845
kill -9 13005
kill -9 13007
kill -9 13009
kill -9 13013
kill -9 13015
kill -9 13017
kill -9 13023
kill -9 13025
kill -9 13029
kill -9 13032
kill -9 13034
kill -9 13036
kill -9 18827
kill -9 13048
kill -9 13063
kill -9 784
kill -9 13276
kill -9 13324
kill -9 13326
kill -9 13328
kill -9 13330
kill -9 13332
kill -9 13334
kill -9 13336
kill -9 13360
kill -9 13486
kill -9 13489
kill -9 13522
kill -9 13560
kill -9 13562
kill -9 13564
kill -9 13723
kill -9 6719
kill -9 529
kill -9 13687
kill -9 32201
kill -9 19050
kill -9 19830
kill -9 561
kill -9 625 ------>pid 625进程
kill -9 1037

76 rows selected.