Look carefully at the following (genuine) extract
from a 9.0.1.3 trace file, and examine the TIM=
entries:
PARSING IN CURSOR #2 len=210 dep=1 uid=0 oct=3 lid=0
tim=1019495629365212 hv=787810128 ad='6e0a278'
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt,
timestamp#, sample_size,
Hello Jonathan,
isn't it soft parse (mis=0) ?
regards...
Jonathan Lewis wrote:
Look carefully at the following (genuine) extract
from a 9.0.1.3 trace file, and examine the TIM=
entries:
PARSING IN CURSOR #2 len=210 dep=1 uid=0 oct=3 lid=0
tim=1019495629365212 hv=787810128 ad='6e0a278'
select /*+
You mean a soft parse is allowed to finish before it starts ?
Or maybe it has to be a soft parse, by SYS, on a recursive
statement that uses the rule-based optimiser ;)
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Author of:
Practical Oracle 8i: Building Efficient Databases
Next Seminar -
Do you have any more examples? and if so, is the
second time always suffixed with '00'. I'm wondering
if the concluding time is still centiseconds (or
whatever precision is appropriate to cause the
'problem')
Cheers
Connor
--- Jonathan Lewis [EMAIL PROTECTED]
wrote:
Look carefully at the
Don't lose any sleep on it, but here's another:
PARSING IN CURSOR #1 len=40 dep=0 uid=54 oct=1 lid=54
tim=1019495629370923 hv=1851325355 ad='6cb3450'
alter table TESTLONG modify ( text clob)
END OF STMT
PARSE
#1:c=1,e=11122,p=1,cr=1,cu=0,mis=1,r=0,dep=0,og=4,tim=101949562937
0823
NB - not
Jonathan, beware, I *think* that the Time Travel Option (TTO) is licensed separately.
Stephane Faroult
Oriole Corporation
Performance Tools Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
Hello Jonathan,
I always think twice while talking to a guru. Here is my comment for
your test case:
'tim' columns in these examples are not accurate.
PARSING IN CURSOR #1 len=40 dep=0 uid=54 oct=1 lid=54
tim=1019495629370923 hv=1851325355 ad='6cb3450'
alter table TESTLONG modify ( text clob)
to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Oracle invents time machine - optimizer now faster than light.
Look carefully at the following (genuine) extract
from a 9.0.1.3 trace file, and examine the TIM=
entries