Re: Slow OLTP users 14CPU SunFire

From: Joel Garry <joel-garry_at_home.com>
Date: 7 Jun 2005 13:47:43 -0700
Message-ID: <1118177263.410695.59370@o13g2000cwo.googlegroups.com>

hpuxrac wrote:

> If I were to make a totally blind stab in the dark guess (and that's
> what we want to avoid by getting properly scoped diagnostic data) I
> would wonder if bind variables are not being used by the DML.

My blind stab in the dark would be v$dispatcher_rate, v$shared_server, v$queue and v$circuit. BLGuy, are you connecting the updating jobs dedicated?

MTS is for scalability of number of users, not performance. If you are worried about performance, don't use MTS. If certain operations choke MTS, don't use MTS with them. Those operations include requests for mass quantities of information.

You also might be choking your buffers with some huge scans during those operations, maybe try temporarily moving the read table into the recycle pool after you upgrade to 9, heh heh.

But of course, it is better to know with traces. Even better to understand the basics of the options you are using.

--
@home.com is bogus.
http://www.theregister.co.uk/2005/06/07/win2000_is_most_successful_microsoft_failure/

Received on Tue Jun 07 2005 - 15:47:43 CDT