Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!usc!julius.cs.uiuc.edu!news.cs.indiana.edu!maytag!maytag.waterloo.edu!psalvini
From: psalvini@maytag.waterloo.edu (Paul Salvini)
Newsgroups: comp.databases
Subject: ORACLE: SQL*Plus Connect By
Message-ID: <1991Jan10.033617.16657@maytag.waterloo.edu>
Date: 10 Jan 91 03:36:17 GMT
Sender: psalvini@maytag.waterloo.edu (Paul Salvini)
Distribution: na
Organization: University of Waterloo
Lines: 21

Help!
  I (we) are trying to tune an application that uses hierarchy structures
throughout the system.  The "connect by/start" phrases take too long!
I have used tkprof and explain and the info seems plausible (ie no
full table scans - only index range scans at worst).

Does anybody out there have hints/tricks/suggestions on how to
tune this beast! I know what you're saying - "Its just Oracle!" but
that won't help fix this problem/bottleneck.

The results of the tkprof indicate excessive "Fetch" times with acceptable
"Parse" and "Execute" times.  This hierarchy structure gets called throughout
forms/rpts/Pro*C and is not acceptable as is.  Something must be done
to change this. Any ideas greatly appreciated.

P.S. A call to ORACLE is "in the queue". 
-- 
===============================================================================
Paul A. Salvini                                            (519) 884-1973 x2913
Wilfrid Laurier University            ** INTERNET: psalvini@maytag.UWaterloo.ca 
Department of Computing Services