Funny.
Though not as extreme, I had the same request from a vendor that
is attending to our 'upgrade'.
After complaining that their software continually logged in and never
logged out, and that the database would crash by the end of the day
if they didn't fix, I was asked if I could bump processes from 500 to
1000.
The answer was 'no'.
This would have just delayed the inevitable crash - until after the
consultant
had got on a plane.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/26/2003 02:44 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re:Dealing with 3rd Party Applications
Jeff,
Let's see, the sys admin installed all of it right? Therefore it MUST
be
the sys admin's problem. END OF CONVERSATION.
Now I'm sure the boss isn't going to like that very much, mine would
not.
So we re-install the database MY way. Most of the time the problems
disappear
easily. Otherwise, have the users pay for a vendor consultant to come in
& tell
the sys admin that he messed up.
Right now we're having a problem with a third party help desk
application
that does a bad job cleaning up connections. The vendor recommended
setting
processes = 20000 in the init.ora file & restart the instance every 24
hours.
The help desk manager asked me what I thought of that, you can imagine the
response. Anyway, we're now in MTS mode & the problem has been pushed
back to
the vendor with the "you want us to do WHAT???? Are you crazy??" response.
It's
a shame that vendors don't have Oracle trained people working for them!!
Dick Goulet
PS: If your using a telecom management software product from a company in
Manchester NH, USA, consider yourself LUCKY. They have some real talented
Oracle certified DBA's with experience working for them. They also don't
create
these types of problems.
____________________Reply Separator____________________
Author: "Eberhard; Jeff" <[EMAIL PROTECTED]>
Date: 2/26/2003 12:43 PM
Hi,
So my boss comes over this morning and tells me that the users are having
a
performance problem with a 3rd party application that have recently began
using. This is an oracle database where they bought the software and had
the system admin install the software which included the vendors
instruction
of creating and setting up the database (basically use the defaults). It
is
an Oracle 8.1.7 database on Windows 2000. He wants me to find out "if you
can create some indexes or something", etc. (he likes to give solutions
before the cause if discovered).
Anyway, I decide to take a look at it. The performance they are
complaining about is when they log into the application it takes about a
minute for their initial screen (which includes a list of values) to
appear.
I use the tool that someone posted here a while ago, SQL Monitor from
www.fastalgo.com, and find that during the time the user is waiting for
the
first screen the application is executing a sql statement about 2200
times.
The SQL is: SELECT PARENTID FROM PROC_ WHERE PROCEDUREID=:1
The bind variable is different for each execution with appears to be the
procedureid values from the table proc_. Table proc_ has 2203 rows.
I check the executions for the sql text in v$sqlarea. Executions =
58,825.
(aha, I think this is the problem).
I explain plan the query and find that it is using the primary key index.
My tuning skills are still pretty basic. Since I have no control over the
application is there anything I can do to increase the performance of
running the query thousands of times?
Also how do you usually deal with 3rd party application issues like this?
95% of our databases/applications are from 3rd party vendors and it's a
pain
trying to get them performing better.
Thanks,
Jeff Eberhard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Eberhard, Jeff
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
