SQL Statement with Parse but no Execute or Fetch on Remote Database for Distributed SQL (Doc ID 580301.1)

Last updated on MAY 23, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 7.0 to 11.1
Information in this document applies to any platform.

Goal

When distributed SQL statements are being traced using SQL_TRACE or event 10046 it is possible to trace the session created over the database link in the remote database and examine the performance of the remote SQL fragments in a TKPROF report.

We will see in such reports some SQL fragments which do not correspond to a distributed SQL statement issued by the application being traced. Such statements will have a Parse phase but no Execute or Fetch phases. Here is an example:
SELECT * 
FROM
 "EMP"


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.07       0.08          0          0          0           0
Execute      0      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        1      0.07       0.08          0          0          0           0

What are such "Parse-only" SQL fragments issued to the remote database ?

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