SQL Performance (MOSC)

MOSC Banner

Hint gather_plan_statistics

edited Nov 7, 2013 11:36PM in SQL Performance (MOSC) 3 commentsAnswered
 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     |              |     

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center