10046 trace中的ela是什么指标？

aaaaaaaa2000

版主请问一下，图中的ela是什么意思？


===================================================================================


maclean commented : 10046 trace中的ela是什么指标？

Maclean Liu(刘相兵

WAIT Cursor#: nam=ʹ%sʹ ela=%d p1=%ul p2=%ul p3=%ul
Field                                  Meaning
Cursor # The cursor number.
nam The name of the wait event. The Oracle Server Reference has a complete list of wait events and details on each one.
ela      Elapsed time in hundredths of seconds for the event.
p1, p2, p3 The parameters specific to the wait event. Each event has its own set of parameters. Refer to the Oracle Server Reference for the meaning of p1, p2, p3 for a specific wait event.


ELA  Elapsed time in hundredths of seconds for the event. => 该事件的逝去时间， 单位为百万分之一秒

建议好好读一下Tom kyte的 《Expert one-on-one Oracle》　，　这本书很好地介绍了如何阅读10046 trace

aaaaaaaa2000

多谢版主解答！！！！