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 |
---|---|---|---|
|
|
|
Indicates whether the test is predefined or custom. Possible values:
Predefined tests can be disabled, but not deleted. |
|
|
|
Indicates the test type. Possible values include:
The test type values are the |
|
|
|
SQL test. This column is null for non-SQL tests. |
|
|
|
Optional service name qualifier |
|
|
|
Indicates whether the SQL test is enabled. Possible values:
|
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