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: NT performance issues

RE: NT performance issues

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Fri, 01 Sep 2000 15:12:34 -0300
Message-Id: <10606.116088@fatcity.com>


I'm not sure, but I know they wont be releasing a version of = Windows2000 for
the alphas.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	Place for oracle [SMTP:place4oracle_at_yahoo.com]
	Sent:	Friday, September 01, 2000 6:17 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Re: NT performance issues

	Hello,

	Just one Question or remarks...=20
	NT on Alpha is it still supported I don't think so.

	Regards
	Henrik

	--- Tom Pall <tom_at_cdproc.com> wrote:

> I recently attended the Oracle Internals,
> Backup/Recovery, Events, Optimizer seminars.
>=20
> Your example was the one our instructor used to talk
> about the need for freelists groups and
> lots of freelists.
>=20
> However, I've been told by Oracle Support that log
> switches every few minutes can result in
> really bad things happening to a database, and
> should be avoided by building bigger log files.
>=20
> ----- Original Message -----=20
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, August 30, 2000 12:56 PM
>=20 >=20
> >=20
> > Hello all,
> >=20
> > A client has an Oracle NT database running on a
> Dec/Alpha 2 processor
> > machine. In the factory there are 55 "scanning
> stations". Basically, each
> > station scans UPCs that are stored in the
> database. When they have more
> > than 40 stations scanning, the database "locks up"
> and takes over the=20
> > machine. In the past, they have rebooted the
> database, and decreased the
> > number of scanning stations. I know they have
> issues with redo log switches
> > (seeing 20+/hour). I can't believe that redo log
> issues would cause the
> > database to max the machine. There are some
> triggers that I need to=20
> > investigate. Any/all suggestions welcome.
> >=20
> > Here's some info on the current configuration:
> > OS: NT (sp5)
> > Oracle8 Enterprise Edition 8.0.4.2.0 - Very Large
> Memory (VLM)=20
> > 512M RAM
> > Running in NOARCHIVELOG mode
> >=20
> > compatible =3D 8.0.4.0.0=20
> > db_block_buffers =3D 3200=20
> > db_block_size =3D 8192=20
> > optimizer_mode =3D CHOOSE=20
> > processes =3D 200=20
> > shared_pool_size =3D 12000000=20
> > sort_area_size =3D 65536=20
> > 25 rollback segments
> > --=20
> > Author: McGlaughlin,Stewart
> > INET: mcglaughlin_at_attws.com
> >=20
> > Fat City Network Services -- (858) 538-5051=20
> 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).
>=20
> --=20
> Author: Tom Pall
> INET: tom_at_cdproc.com
>=20
> 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).
=3D=3D=3D=3D=3D Place4oracle=20 http://www.geocities.com/place4oracle/ __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ --=20 Author: Place for oracle INET: place4oracle_at_yahoo.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
Received on Fri Sep 01 2000 - 13:12:34 CDT

Original text of this message

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