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

Last updated on JUNE 07, 2017

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

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