1.40 CLIENT_STATISTICS_LEVEL

CLIENT_STATISTICS_LEVEL controls whether database clients report network statistics to the database.

This parameter applies only to clients that use Oracle Call Interface (OCI) to connect to the database.

Property Description

Parameter type

String

Syntax

CLIENT_STATISTICS_LEVEL = { TYPICAL | OFF }

Default value

TYPICAL

Modifiable

ALTER SYSTEM ... DEFERRED

Modifiable in a PDB

Yes

Basic

No

Oracle RAC

The same value must be used on all instances.

Database clients sometimes have performance issues when interacting with the database over a network (LAN or WAN). You can use this parameter to enable clients to collect network statistics and periodically send them to the database, where the statistics are displayed in AWR and V$ views. These statistics include TCP and SQL*Net statistics. They complement existing database statistics and can be used to analyze, troubleshoot, and tune potential network performance or configuration issues.

Possible values:

  • TYPICAL

    This setting enables clients to collect network statistics and periodically report them to the database.

  • OFF

    This setting disables this feature. Clients will not report network statistics to the database.

When you modify this parameter, the new setting applies only to subsequent new connections to database clients.

Note:

To view a complete listing of the statistics that are collected and reported when this feature is enabled, issue the following SQL statement:

SELECT name FROM V$STATNAME
  WHERE name LIKE 'Client%' ORDER BY name;

NAME
-----------------------------------------------------
Client Advertised Receive Window
Client Advertised Send Window
Client Data Segments In
Client Data Segments Out
Client Lost Packets
Client Path Maximum Transmission Unit(MTU)
Client Send Congestion Window
Client Time (usec) Busy Sending Data
Client Time (usec) Busy Sending Data under Congestion
Client Time (usec) Last Ack Received
Client Time (usec) Last Ack Sent
Client Time (usec) Last Data Received
Client Time (usec) Last Data Sent
Client Time (usec) Limited by Receive Window
Client Time (usec) Limited by Send Buffer
Client Time (usec) Round Trip Time
Client Time (usec) Round Trip Time Variance
Client Total Bytes Acked
Client Total Bytes Received
Client Total Number of Retransmitted Packets

Note:

This parameter is available starting with Oracle Database release 19c, version 19.1.