Re: Caclutating execution time

From: Taral Desai <taral.desai_at_gmail.com>
Date: Tue, 26 Jan 2010 17:12:53 -0600
Message-ID: <2b0cd5cd1001261512m75091644wdbd36572708a2e31_at_mail.gmail.com>



Hi Ric,

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
Received on Tue Jan 26 2010 - 17:12:53 CST

Original text of this message