Egorts,
Thanks for the reply but I do not think so since our instance has that set to TYPICAL and here is the test I did below:
select *
from
fnd_user where user_name = 'BPHAM'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00
0 0 0 0
Fetch 2 0.00 0.00 0 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 3 0 1
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS
Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID FND_USER
1 INDEX UNIQUE SCAN FND_USER_U2 (object id 33856)
********************************************************************************
alter session set sql_trace = false
From: "Egor Starostin" <egorst@xxxxxxxxx>
Reply-To: egorst@xxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
CC: binhpham15@xxxxxxxxxxx
Subject: Re: Why no row source plans in tkprof output? -- More info please read...
Date: Wed, 25 Apr 2007 11:41:20 +0400
>Binh,
>
>>I do see stats written for some of the SQL's in the raw trace file,
>>however,
>>there is no row source plans for any of the SQL's in the tkprof
>>output file.
>
>I believe you need to set statistics_level=all in order to get row
>source execution statistics in STAT lines.
>
>By default, statistics_level set to 'typical' value and although
>rows
>source execution stats is gathered in v$segstat it doesn't displayed
>in 10046 trace files.
>
>
>--
>Egor
>http://www.oracledba.ru
>--
>//www.freelists.org/webpage/oracle-l
>
>
