Hello,

Can somebody suggest, what could be the problem and how I should start
investigating it ?

When I try to save the data through forms it is taking 2 minutes and 30
Seconds for each save.

I am using Oracle 8.1.7.3 and forms 6i on Suse Linux 7.1

Please suggest how to start the diagnose ?

Thanks, Raj

On 28 Aug 2006 02:33:45 -0700, "Raj" <rajeev.tomar@gmail.com> wrote:

>Hello,
>
>Can somebody suggest, what could be the problem and how I should start
>investigating it ?
>
>When I try to save the data through forms it is taking 2 minutes and 30
>Seconds for each save.
>
>I am using Oracle 8.1.7.3 and forms 6i on Suse Linux 7.1
>
>Please suggest how to start the diagnose ?
>
>Thanks, Raj

Please do not multi-post and/or crosspost

--
Sybrand Bakker, Senior Oracle DBA

Too few information to make any comments. I would suggest to turn on
all kind of tracing to see where the bottleneck is. Examples would be
tracing the forms, tracing the sqlnet on the client and server side,
tracing the sql session. Tracing the network etc.

Raj wrote:
> Hello,
>
> Can somebody suggest, what could be the problem and how I should start
> investigating it ?
>
> When I try to save the data through forms it is taking 2 minutes and 30
> Seconds for each save.
>
> I am using Oracle 8.1.7.3 and forms 6i on Suse Linux 7.1
>
> Please suggest how to start the diagnose ?
>
> Thanks, Raj

Well the first thing I'd suggest is patch to 8.1.7.4.

Then I'd suggest trying the exact same transaction using SQL*Plus and
see if it is similarly slow.

Are all forms slow or just one? In general I would expect sub-second saves.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Hello Daniel,

I will apply the patch as suggested by you.

When I execute the query (transaction) with sqlplus it is very fast but
with forms it is very slow.

Any pointers ??

Thanks, Rajeev

> Well the first thing I'd suggest is patch to 8.1.7.4.
>
> Then I'd suggest trying the exact same transaction using SQL*Plus and
> see if it is similarly slow.
>
> Are all forms slow or just one? In general I would expect sub-second saves.
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Raj wrote:
> Hello Daniel,
>
> I will apply the patch as suggested by you.
>
> When I execute the query (transaction) with sqlplus it is very fast but
> with forms it is very slow.
>
> Any pointers ??
>
> Thanks, Rajeev

First pointer is don't top post. Scroll to the bottom before replying.

Given that it is a Forms issue and not a database issue which version of
Forms? Running client-server or in a web browser? Which one?

Are all forms slow or just this one?

Are all actions in this form slow or just this one?

Which triggers are fired when you take the slow action?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org