RE: Need help with tkprof output from long-running query

From: Jain, Akshay <Akshay.Jain_at_cit.com>
Date: Fri, 11 Aug 2000 16:13:35 -0400
Message-Id: <10586.114409@fatcity.com>

The first place is the full table scans:

  31949           TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                      'TIPS_SECURITY_LOOKUP_REP'
   4976          TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                     'TIPS_REP_DIM'

Actually, it looks like your query is accessing views, but you have not supplied here the view definitions nor the physical indexes of the underlying tables. I hope my interpretation is correct here, it seems that "TIPS_SECURITY_LOOKUP" etc. are the underlying tables.

Can you pursue this, or is it a bad path to go for?

Akshay Jain

---

Newcourt-CIT
Tel. (416) 507-5385
mailto:Akshay.Jain_at_cit.com

---

-----Original Message-----
From: Cherie_Machler_at_gelco.com [mailto:Cherie_Machler_at_gelco.com] Sent: Friday, August 11, 2000 2:34 PM
To: Multiple recipients of list ORACLE-L Subject: Need help with tkprof output from long-running query

attached the text from the trace.

Does anyone have any ideas on where to start looking?(See attached file: matt1046.prf)

Thanks for taking time to help, Received on Fri Aug 11 2000 - 15:13:35 CDT