DBA Scripts: services.sql (Oracle 11g)

分享于 

1分钟阅读

DBA 脚本

  繁體
 
-----------------------------------------------------------------------------------
 
File Name : https://oracle-base.com/dba/monitoring/services.sql 
Author : Tim Hall 
Description : Displays information about database services. 
Requirements : Access to the DBA views. 
Call Syntax : @services 
Last Modified: 05/11/2004 
-----------------------------------------------------------------------------------
 
SET LINESIZE 200 COLUMN name FORMAT A30 COLUMN network_name FORMAT A50 COLUMN pdb FORMAT A20 

SELECT name, network_name, pdb 
FROM dba_services 
ORDER BY name;



服务  services  scripts  dba  11g