Re: Caclutating execution time

Thanks for your quick response. But can you please let me know how to get that information. Also, if possible please explain in detail

On Tue, Jan 26, 2010 at 4:48 PM, Ric Van Dyke <ric.van.dyke_at_hotsos.com>wrote:

> You need the timing from the Query Coordinator process. It will include
> the time of the Parallel operation(s).
>
>
>
> -----------------------
>
> Ric Van Dyke
>
> Hotsos Enterprises
>
> -----------------------
>
>
>
> *Hotsos Symposium *
>
> *March 7 – 11, 2010 *
>
> *Be there.*
>
>
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Taral Desai
> *Sent:* Tuesday, January 26, 2010 2:37 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Caclutating execution time
>
>
>
> Hi ,
>
>
>
> I had one query which ran in parallel. Now i want to know it's total
> execution time but from last snap 7621 which says it ran for 126 hrs but i
> actually hadn't took that much. So, how to calculate real elapsed time.
>
>
>
> Oracle 10.2.0.3
>
>
>
> select snap_id ,px_servers_execs_total,
> elapsed_time_delta,elapsed_time_total,rows_processed_delta,rows_processed_total
> from dba_hist_sqlstat where sql_id='xxxxxxx' order by snap_id
>
>
>
> SNAP_ID PX_SERVERS_EXECS_TOTAL ELAPSED_TIME_DELTA
> ELAPSED_TIME_TOTAL ROWS_PROCESSED_DELTA ROWS_PROCESSED_TOTAL
>
> ---------------------- ---------------------- ----------------------
> ---------------------- ---------------------- ----------------------
>
> 7607 0 4153020665
> 4153020665 0 0
>
> 7608 0 36977318939
> 41130339604 0 0
>
> 7609 0 37235891337
> 78366230941 0 0
>
> 7610 0 37284697558
> 115650928499 0 0
>
> 7611 0 36607129876
> 152258058375 0 0
>
> 7612 0 36039518358
> 188297576733 0 0
>
> 7613 0 34306595434
> 222604172167 0 0
>
> 7614 0 30405519446
> 253009691613 0 0
>
> 7615 0 30507144568
> 283516836181 0 0
>
> 7616 0 25704117849
> 309220954030 0 0
>
> 7617 0 30432670103
> 339653624133 0 0
>
> 7618 0 34781694387
> 374435318520 0 0
>
> 7619 8 31990802430
> 406426120950 0 0
>
> 7620 8 31560702139
> 437986823089 0 0
>
> 7621 16 16701287279
> 454688110368 1141685776 1141685776
>
>
> --
>
> Thanks & Regards,
> Taral Desai
> Joan Crawford<http://www.brainyquote.com/quotes/authors/j/joan_crawford.html> - "I, Joan Crawford, I believe in the dollar. Everything I earn, I spend."
>

-- 

Thanks & Regards,
Taral Desai
Samuel Goldwyn<http://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html>
- "I don't think anyone should write their autobiography until after
they're dead."

--
http://www.freelists.org/webpage/oracle-l