1.39 CLIENT_STATISTICS_LEVEL

CLIENT_STATISTICS_LEVEL controls whether database clients report network statistics 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 send them to the database.

  • OFF

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

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

Note:

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