My Oracle Support Banner

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

Last updated on DECEMBER 16, 2023

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.