Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Clash of the DBs in eWeek

RE: Clash of the DBs in eWeek

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Thu, 28 Feb 2002 12:41:45 -0800
Message-ID: <F001.0041BC24.20020228124145@fatcity.com>


On the MTS part, my faux pas. I saw the first "dispatchers" commented out along with the other "mts%" params.

Also, on closer inspection, I was looking at "create_nile2_database_details.htm" in the "C - Create Benchmark Database" folder in the .zip file when I saw that "processes" was set to 150. Perhaps they made changes to the init.ora (from the "B - Configure Database Server" folder) after an initial GUI DB create?

Thanks, Brian, and thanks all else that pointed out the JDBC connection pooling. I've been trying to take a look at that stuff, but I've got no time here at work and I can't run Oracle at home on my Linux/Alpha box. <sigh>

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA


-----Original Message-----
Sent: Thursday, February 28, 2002 1:14 PM To: Multiple recipients of list ORACLE-L

Which docs? I looked at the init.ora file, and it had:

    processes=530

and MTS enabled.

Brian

--
--------------------------------------
| Brian McGraw     --     Oracle DBA |
| Central Alabama Oracle Users Group |
--------------------------------------

Rachel Carmichael wrote:


> they lie?
>
> --- "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> wrote:
> > Anybody happen to see the cover story on the 02/25/2002 iss of eWeek
> > titled
> > "Database Clash"?
> >
> > The pretty graphs say that their tests showed that Oracle and MySQL
> > rocked
> > the other DBs they tested (including MS SQueaL Server). So I
> > investigated.
> > I went to http://www.eweek.com/ and downloaded the "Online Exclusive:
> > Download our configuration and tuning scripts".
> >
> > According to the Oracle setup docs in there, they're NOT using MTS
> > and
> > processes in init.ora is 150. So then how did they test for 1000
> > "concurrent Web clients"?
> >
> > Anyone have a thought?
> >
> >
> > Rich Jesse System/Database Administrator
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).
Received on Thu Feb 28 2002 - 14:41:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US