SQL ID is Missing in TKPROF Outputs
(Doc ID 2699569.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterOracle 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
- TKPORF output does not show the SQL ID for some SQL statements as depicted in the sample TKPROF and raw 10046 trace file below:
********************************************
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 |