Re: slow inserts from Web into Oracle on Unix

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Tue, 13 Aug 2002 10:29:50 -0500
Message-ID: <ajb8it$868$1@news.gte.com>

Ashok,

Trace a one minute session on both NT and UNIX. Make sure you have TIMED_STATISTICS=TRUE at the server level first. Post the results of the tkprof output here.

-Kevin

"Ashok Kumar" <avkumar_71_at_hotmail.com> wrote in message news:55c46351.0208122056.60c27a4_at_posting.google.com...
> Hi,
>
> We have a Web App with ASP Scripts, IIS and Oracle Backend.
>
> Inserting data from the web to Oracle on a NT Box gets me approx 8000
> Rows / 60 seconds.
>
> Inserting data from the web to Oracle on a UNIX Box gets me approx 800
> Rows / 60 seconds.
>
> Any pointers to what might be contributing to such a slow response
> from the UNIX box. The Oracle version is 8.06. The Web Server and the
> database are on seperate physical boxes.
>
> Many thanks
> ashok
Received on Tue Aug 13 2002 - 10:29:50 CDT