Re: Transaction slowness

Hi Rajeev,

Thanks for the response.

The mobile devices are using Oracle MWA for WMS operations accessing EBS database. This is Java based mobile app framework.

Regards,
Amit

On Thu, Oct 14, 2021 at 9:38 PM Rajeev Prabhakar <rprabha01_at_gmail.com> wrote:

> Amit,
>
> I could be way off the mark, but, just wondering if
> this the case of jsp files getting created/compiled
> on the first time invocation by the App given that
> this is done via mobile device ?
>
> The subsequent calls could be utilizing the cached /
> compiled jsp files, so, are faster…
>
> If not, perhaps you could give some background on
> the interface/language being used by the App ?
>
> My point, unless you have already ruled it out, there
> could be variables/factors outside of the database
> layer contributing to the initial sluggishness..
>
> Rajeev
>
> On Oct 14, 2021 at 6:55 PM, <Amit Saroha <eramitsaroha_at_gmail.com>> wrote:
>
> Hello All,
>
> We are facing a weird slowness in database response to users. The
> situation is - Warehouse operators are unloading trucks on the dock and
> moving material to locators. When they are doing the activity, they have to
> scan barcodes on a mobile device and keep moving items in locators to clean
> up the dock to make a way for another truck for unloading material. When
> the user is doing the first transaction on a mobile device, it takes 5-10
> minutes, but the next transactions are complete in 5-10 seconds. The delay
> in first transaction completion is causing an overall delay in warehouse
> work efficiency.
>
> 10046 traces enabled on the session while doing the first transaction,
> which takes 5-10 minutes, revealed that over 80% of the time is going in
> SQL*NET message from the client. Trace for the next sessions also shows the
> same event is top, but the transaction completes within 10 seconds.
>
> We don’t understand why the first transaction is taking time, and the next
> is not so struggling to fix the issue. We also don’t want to conclude it as
> a network issue because subsequent transactions are quick.
>
> We would appreciate it if any of you could please tell us if anyone has
> observed the same situation and what we can do to rectify such behavior?
>
> Thank you in advance for your inputs.
>
>
> Best Regards,
> AMIT
>
> --
Best Regards,
AMIT SAROHA

--
http://www.freelists.org/webpage/oracle-l