139.4.4 SHOW_CLIENT_STATUS Function

The SHOW_CLIENT_STATUS function returns the status of the specified client.

Syntax

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

Parameters

Table 139-7 SHOW_CLIENT_STATUS Function Parameters

Parameter	Description
client_id	Specifies the ID of the client. The default is NULL indicating all clients.
service_cat	The service category.

Usage Notes

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

[{"Id":Client's id,"Name":"Client's name","Event":0 or 1,"Stats":0 or 1,"Interval":Number}]

Examples

The following example illustrates how to show the status of all IPIF clients within an anonymous PL/SQL block:

set serveroutput on;
DECLARE
  client_status VARCHAR2;
BEGIN
  SELECT dbms_netmon.show_client_status(null, dbms_netmon.ipif_service) INTO client_status;
  dbms_output.put_line(client_status);     
END;
/

PL/SQL procedure successfully completed.