Oracle教程 2023-04-07

Oracle 视图 V$PLSQL_DEBUGGABLE_SESSIONS 官方解释，作用，如何使用详细说明

V$PLSQL_DEBUGGABLE_SESSIONS视图用于列出当前允许PL/SQL调试的会话。它列出了允许调试的会话，每一行代表一个会话。

用于检查正在受调试的会话，或是查询某个具体会话当前调试的状态，可以使用V$PLSQL_DEBUGGABLE_SESSIONS视图。

使用方法：

1. 首先通过查询V$PLSQL_DEBUGGABLE_SESSIONS视图检查有哪些会话允许PL/SQL调试：
SELECT * FROM V$PLSQL_DEBUGGABLE_SESSIONS;

2. 然后，可以查看单个会话的调试状态，比如查看SID为50的会话的调试状态：
SELECT * FROM V$PLSQL_DEBUGGABLE_SESSIONS WHERE SID = 50;

3. 如果要终止某个会话的调试，则可以对对应的V$PLSQL_DEBUGGABLE_SESSIONS中的记录执行UPDATE操作：
UPDATE V$PLSQL_DEBUGGABLE_SESSIONS SET DEBUGGABLE = ‘NO’ WHERE SID = 50;

V$PLSQL_DEBUGGABLE_SESSIONS shows the current sessions of all users that the current user has privileges to debug with a PL/SQL debugger.

Column	Datatype	Description
`SID`	`NUMBER`	Session identifier
`SERIAL#`	`NUMBER`	Session serial number
`LOGON_TIME`	`DATE`	Time of logon
`USER#`	`NUMBER`	Oracle user identifier
`USERNAME`	`VARCHAR2(128)`	Oracle user name
`OSUSER`	`VARCHAR2(128)`	Operating system client user name
`PROCESS`	`VARCHAR2(24)`	Operating system client process ID
`MACHINE`	`VARCHAR2(64)`	Operating system client machine name
`PORT`	`NUMBER`	Operating system client port number
`TERMINAL`	`VARCHAR2(30)`	Operating system client terminal name
`PROGRAM`	`VARCHAR2(84)`	Operating system client program name
`TYPE`	`VARCHAR2(10)`	Session type
`SERVICE_NAME`	`VARCHAR2(64)`	Service name of the session
`PLSQL_DEBUGGER_CONNECTED`	`VARCHAR2(5)`	Indicates whether the session is connected to a PL/SQL debugger. Possible values: `TRUE` `FALSE`
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：