Re: Slow response of Oracle forms

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_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org