Re: Slow response of forms

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 28 Aug 2006 12:09:35 +0200
Message-ID: <c3g5f2l57qhn8bhhb0bjnnvg2lhmfa792k@4ax.com>

On 28 Aug 2006 02:34:29 -0700, "Raj" <rajeev.tomar_at_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

The usual:
find out what is waiting for.
Find out the session id
check v$session_event
check v$session_wait
and/or set up an after logon trigger to enable event 10046, level 12

Other than that: both 8.1.7.3 and forms 6i are desupported.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Aug 28 2006 - 05:09:35 CDT