My Oracle Support Banner

RDBPROD: Poor response times on OCI queries using SQL/Services version 7.2 (Doc ID 1135953.1)

Last updated on MAY 03, 2018

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.2 to 7.3.0.2 [Release 7.2 to 7.3]
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

Poor performance from OCI connections to Rdb using SQL/Services when performing a:

CREATE TABLE FROM SELECT * FROM RDBTABLE@DBLINK;


or any variation that will query an Rdb table in SQLPLUS or SQLNET front-end.

A query taking seconds or minutes using a direct connection within Rdb is seen to take hours over a SQLNET connection.

The issue is more noticeable when retrieving data from larger tables.

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!


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