Oracle教程 2023-02-24

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

Oracle视图 DBA_HIST_SERVICE_NAME 用于查询已缓存的服务名列表，以及对应的实例号和时间戳等信息。

使用方法：

1、登录Oracle，输入SQL查询命令：SELECT service_name, SID, timestamp FROM dba_hist_service_name ORDER BY timestamp;

2、可以在where子句中增加过滤条件，比如下面例子：SELECT service_name, SID, timestamp FROM dba_hist_service_name WHERE status = ‘ACTIVE’ ORDER BY timestamp;

3、查看返回结果，查看缓存的服务名、实例号、状态等信息。

DBA_HIST_SERVICE_NAME displays the names of the Services tracked by the Workload Repository.

This view contains information for V$SERVICES.

Column	Datatype	NULL	Description
`DBID`	`NUMBER`	`NOT NULL`	Database ID for the snapshot
`SERVICE_NAME_HASH`	`NUMBER`	`NOT NULL`	Hash of the service name
`SERVICE_NAME`	`VARCHAR2(64)`	`NOT NULL`	Name of the service
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. 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