Hint gather_plan_statistics
Hi,
I have a question . I am using the /*+ gather_plan_statistics */ hints on my query . As you can see below . I want to know what is the total elapsed time when we used this hint .
Is it A-TIME on the Top i.e 3.63 or it is total sum of A-TIME from bottim to Up i.e 3.63+00:00:03.20+00:00:00.86 +00:00:02.41?
PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SQL_ID a36w6pfkgp2sy, child number 0 ------------------------------------- select /*+ gather_plan_statistics */ avg(x*2) from ( select /* t1_nl_join_agg.sql */ t1.x, t2.y from kso.t1 t1, kso.t2 t2 where t1.y = t2.x ) Plan hash value: 174109304 ---------------------------------------------------------------------------------------------- | Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | ---------------------------------------------------------------------------------------------- | 1 | SORT AGGREGATE | |
1