4.168 DBA_CONNECTION_TESTS

DBA_CONNECTION_TESTS provides information about connection tests in use for CDBs and PDBs.

This view shows SQL and non-SQL connection tests.

Column Datatype NULL Description

PREDEFINED

VARCHAR2(1)

Indicates whether the test is predefined or custom. Possible values:

  • Y: The test is predefined.

  • N: The test is added by the user.

Predefined tests can be disabled, but not deleted.

CONNECTION_TEST_TYPE

VARCHAR2(15)

Indicates the test type. Possible values include:

  • SQL_TEST: Application servers and applications use SQL tests to check the validity of a connection. Use this value for SQL based connection tests, for example (SELECT 1 FROM DUAL;)

  • PING_TEST: Used when you are using tests that use the ping function to test the connection, including the OCIPing, isValid, isUsable, connection.status, and PING_DATABASE connection tests.

  • ENDREQUEST_TEST: Used when request boundaries are received at the RDBMS. Oracle Connection Pools and all application servers using JDK9 send request boundaries to the RDBMS starting in Oracle Database 12c Release 2 (12.2.0.1).

The test type values are the CONNECTION_TEST_TYPE parameter values that can be specified for the ENABLE_CONNECTION_TEST, DISABLE_CONNECTION_TEST, ADD_CONNECTION_TEST, and DELETE_CONNECTION_TEST procedures for the DBMS_SESSION PL/SQL package.

SQL_CONNECTION_TEST

VARCHAR2(64)

SQL test. This column is null for non-SQL tests.

SERVICE_NAME

VARCHAR2(128)

Optional service name qualifier

ENABLED

VARCHAR2(1)

Indicates whether the SQL test is enabled. Possible values:

  • Y: The test is enabled.

  • N: The test is not enabled.

See Also:

Oracle Database PL/SQL Packages and Types Reference for additional information about the ENABLE_CONNECTION_TEST procedure for the DBMS_SESSION PL/SQL package