The [default test table name] is incorrect. (Doc ID 2236174.1)

Last updated on FEBRUARY 28, 2017

Applies to:

Oracle WebLogic Server - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

 On : 12.1.3.0~ version

Document : Fusion Middleware Administering JDBC Data Sources for Oracle WebLogic Server 12.1.3

Chapter : Database Connection Testing Options

 

On table 17-1, the Default Test Table Name is [SQL ISVALID] for Oracle Database.

However there are below contents is the Document:

Although not as thorough as using the default value SQL SELECT 1 FROM DUAL, SQL ISVALID significantly eliminate processing overhead and improve SOA workload performance.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms