Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: NT performance issues
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:Received on Fri Sep 01 2000 - 13:12:34 CDT
> 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
![]() |
![]() |