My Oracle Support Banner

SQL ID is Missing in TKPROF Outputs (Doc ID 2699569.1)

Last updated on AUGUST 14, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database - Standard Edition - Version 10.1.0.2 and later
Oracle Database - Personal Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Symptoms

 

TKPROF sample outputs:

********************************************

SQL ID: 0zkpy7fsa27fw Plan Hash: 4122059633                             <<<===== The SQL ID is present here for this query!

select *
from
test1
:

*********************************************
                                                                                                            <<<===== The SQL ID is not provided for this query here!
select *
from test1
:

********************************************

Raw 10046 trace file:
PARSING IN CURSOR #46925226268096 len=19 dep=0 uid=181 oct=3 lid=181
tim=1318314751870878 hv=2963348956 ad='6eab4578' sqlid='0zkpy7fsa27fw'
select * from test1                                                                            <<<===== The query text is captured in a single line.
:  
PARSING IN CURSOR #46925226268096 len=19 dep=0 uid=181 oct=3 lid=181
tim=1318314751905494 hv=1791934544 ad='6eab3c28' sqlid='5r4hv6jpcxh2h'
select *                                                                                              <<<===== The query text is captured in multiple lines.
from test1
:



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

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