Oracle教程 2023-02-24

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

, V$SQL

Oracle视图是一种特殊的数据表，它可以以视图的形式被多个客户端动态的访问，提供了一种灵活的检索数据的方法。

V$TOPLEVELCALL及V$SQL是Oracle视图，它们可以用来查看当前正在执行的SQL语句的调用栈。V$TOPLEVELCALL查看当前与客户端连接的所有调用堆栈信息，V$SQL查看系统中开始对客户端活动或连接访问服务器时使用的SQL语句。

查看V$TOPLEVELCALL及V$SQL的语句如下：

SELECT * FROM V$TOPLEVELCALL;
SELECT * FROM V$SQL;

V$TOPLEVELCALL displays the mapping between Oracle top level calls and names.

Column Datatype Description

Column	Datatype	Description
`TOP_LEVEL_CALL#`	`NUMBER`	Oracle top level call number
`TOP_LEVEL_CALL_NAME`	`VARCHAR2(64)`	Oracle top level call name
`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

TOP_LEVEL_CALL#

NUMBER

Oracle top level call number

TOP_LEVEL_CALL_NAME

VARCHAR2(64)

Oracle top level call name

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