5.237 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 and DISABLE_CONNECTION_TEST procedures for the DBMS_APP_CONT_ADMIN 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_APP_CONT_ADMIN PL/SQL package