Caclutating execution time
From: Taral Desai <taral.desai_at_gmail.com>
Date: Tue, 26 Jan 2010 16:37:15 -0600
Message-ID: <2b0cd5cd1001261437y632a5646v3a47d3459c695616_at_mail.gmail.com>
Hi ,
Date: Tue, 26 Jan 2010 16:37:15 -0600
Message-ID: <2b0cd5cd1001261437y632a5646v3a47d3459c695616_at_mail.gmail.com>
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."
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 26 2010 - 16:37:15 CST