Re: Forms application: slow on 1 instance fast on all other

From: Alan Mills <Alan.Mills_at_nospamservices.fujitsu.com>
Date: Tue, 8 Oct 2002 13:23:30 +0100
Message-ID: <anuio3$tve$1_at_news.icl.se>


I agree! If it is the same Oracle instance it sounds like each user (is this what you meant by instance?) has different tables. Check the sysnonyms used and permissions. Maybe one set of tables is not indexed. It has happened!

"Jeff" <jeff_at_work.com> wrote in message news:anuhn7$43j$1_at_cronkite.cc.uga.edu...
> It sounds like you're talking about not only separate instances, but
separate
> databases as well. I'd say look at tuning the problem database. But to
prove
> it's not Forms, have you tried querying the data with SQLPlus to see if
the
> problem still occurs?
>
>
> In article <s3lo9.527436$2I.17025508_at_nlnews00.chello.com>, "Stephan"
> <test_at_test.com> wrote:
> >Oracle 7.3.4 and higher. Forms 6i.
> >
> >Hi,
> >
> >Our forms application is fast for all instances, except 1.
> >
> >I used TKPROF to analyze what's happening.
> >I see some rows have timings of 3 seconds, while
> >these timings are 0 on the normal/fast instances.
> >
> >The only difference between the fast and slow instances
> >is the amount of records in 1 certain table. This table -however-
> >is NOT referenced in the form.
> >
> >So I wonder: can 1 table -which is NOT used in the form- slow
> >down that form?
> >
> >I am seeking for a direction to figure out what's the cause.....
> >
> >Thanks
> >Stephan
> >
> >
Received on Tue Oct 08 2002 - 14:23:30 CEST

Original text of this message