Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance issue in a function

Re: Performance issue in a function

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 12 Jul 2006 09:38:57 -0700
Message-ID: <1152722339.53494@bubbleator.drizzle.com>


Sujatha wrote:
> Hi,
>
> I have a main view from where all the columns are displayed at front
> end.
> This view has 6 subqueries in it, of which in one of the view, if i
> comment a function to get an amount based on a input value, it brings
> records in 10-15 secs. If i dont comment, then it takes about 2 mins.
>
> The same function i have used in other views but only in this view it
> is taking a long time. This view retrieves more than 2500 records but
> the others has very few records(say about 10-15 records at the max.)
>
> Can anybody give me any suggestions to solve the problem?
>
> Note:
> I have used cost based optimizer. All my tables are analyzed and have
> statistics collected.
>
> Thanks
> Regards
> Sujatha.k

No SQL
No Explain Plan
No version

No Advice.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Jul 12 2006 - 11:38:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US