My Oracle Support Banner

RDBPROD: How to view the specific query passed to an OCI service (Doc ID 222109.1)

Last updated on APRIL 14, 2022

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.1.6 and later
HP OpenVMS Itanium
HP OpenVMS Alpha
HP OpenVMS VAX

Goal

Sometimes it is necessary to look at the exact queries passed to OCI Services. Depending on the access paths used, the queries can be transformed in various ways, so this can be a little tricky.

Solution

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.