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

Thanks Mark for your input.

• On Mon, 1/26/09, Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com> wrote: From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com> Subject: Re: ** identify time/number for individual table, index accesss within a sql To: ajoshi977_at_yahoo.com Cc: oracle-l_at_freelists.org, ajoshi97_at_yahoo.com 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.

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