Re: ** identify time/number for individual table, index accesss within a sql

From: A Joshi <>
Date: Tue, 27 Jan 2009 16:24:44 -0800 (PST)
Message-ID: <>

Thanks Riyaj. I am going thru and trying to identify.

Thanks Mark for your input.

  • On Mon, 1/26/09, Riyaj Shamsudeen <> wrote: From: Riyaj Shamsudeen <> Subject: Re: ** identify time/number for individual table, index accesss within a sql To: Cc:, Date: Monday, January 26, 2009, 9:30 AM

Hello Joshi
If I understand correctly, you are trying to find which step of the plan is taking longer time? I blogged about this last year.



Riyaj Shamsudeen
Principal DBA, 
Ora!nternals -
Specialists in Performance, Recovery and EBS11i

On Thu, Jan 22, 2009 at 10:02 AM, A Joshi <> wrote:


  For : OLTP database 

Oracle version : 10G

OS : SunSolaris

For a procedure taking a long time  : I have taken a 10046 trace.
From that I  can do tkprof and get the times for  individual
sql. Now : How do I get time taken for and number of table, index
accesses within a sql query. For example : i have sql joining upto 6
tables and some are full table scan and some are index access. I want
to know which one is taking time. Please help and thanks.  I am
able to estimate full table time by running it from sqlplus. I think
full table with some checks takes longer. For index access : I can
estimate for single index scan : however : i do not know how index
scans are taking place. From the explain plan I was trying to go in the
order : but there also doing the order is not easy. Can someone help me
figure this out. Thanks



Received on Tue Jan 27 2009 - 18:24:44 CST

Original text of this message