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

From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com>
Date: Mon, 26 Jan 2009 08:30:59 -0600
Message-ID: <203315c10901260630x69a4f90bxc49ce0b1736e3f11_at_mail.gmail.com>



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.

http://orainternals.wordpress.com/2008/04/15/how-to-tune-sql-statements-scientifically/

HTH

-- 
Cheers

Riyaj Shamsudeen
Principal DBA,
Ora!nternals -  http://www.orainternals.com
Specialists in Performance, Recovery and EBS11i
Blog: http://orainternals.wordpress.com

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


> Hi,
> 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
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 26 2009 - 08:30:59 CST

Original text of this message