Re: ASP/OraOLEDB performance

From: Mark Weaver <mark_at_npsl.co.uk>
Date: Sat, 27 Oct 2001 13:34:44 +0100
Message-ID: <FRxC7.12116$a14.351847@news6-win.server.ntlworld.com>

> 1. Don't know - who specified this number of connections for MTS and
> wrote the application to open so many?
Each ASP page is presumably opening a separate request, indicating that OLEDB connection pooling isn't working perhaps?

> 2. Don't know - how big is the SGA, what are the buffer hit ratios,
> what kind of disk performance are you getting, what kind of network
> issues are you having, etc.

The DB is hardly under stress. I can repeat the experiment with OCI written code with excellent performance. However, I have a need for ASP+ADO, which I just can't get to work at all well. I can't believe that I'm doing something uncommon here? Surely something must be wrong somewhere!

> 3. Have your DBA start investigating issues in #1 and #2.
That's me :-)

> --
> Ron Reidy
> Oracle DBA
> Reidy Consulting, L.L.C.
Received on Sat Oct 27 2001 - 07:34:44 CDT