139.4.5 SHOW_SERVICE_STATUS Function

The SHOW_SERVICE_STATUS function returns the status of all NMON services.

Syntax

DBMS_NETMON.SHOW_SERVICE_STATUS( client_id    IN BINARY_INTEGER DEFAULT NULL,
                                 service_cat  IN BINARY_INTEGER );

Parameters

Table 139-8 SHOW_SERVICE_STATUS Function Parameters

Parameter	Description
client_id	The client id. The default is NULL, meaning all clients.
service_cat	The services category. The default is all services.

Usage Notes

The SHOW_CLIENT_STATUS function returns a VARCHAR2 containing a list of JSONs as follows:

[{"Service":"Service Name","Type":"Event or Stats","Enabled":0 or 1}]

Examples

The following example illustrates how to sshow the status of the system service within an anonymous PL/SQL block:

set serveroutput on;
DECLARE
  v_service_status VARCHAR2;
BEGIN
  SELECT dbms_netmon.show_service_status(dbms_netmon.system_service) INTO v_service_status;
  dbms_output.put_line(v_service_status);     
END;
/

[{"Service":"SystemEventStats","Type":"Event","Enabled":1},{"Service":"SystemEve
ntStats","Type":"Stats","Enabled":1}]

PL/SQL procedure successfully completed.