Re: NT performance issues

From: Place for oracle <place4oracle_at_yahoo.com>
Date: Thu, 31 Aug 2000 23:24:37 -0700 (PDT)
Message-Id: <10606.116046@fatcity.com>

Hello,

Just one Question or remarks...
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.
  >
  > Your example was the one our instructor used to talk
  > about the need for freelists groups and
  > lots of freelists.
  >
  > 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.
  >
  > ----- Original Message -----
  > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > Sent: Wednesday, August 30, 2000 12:56 PM
  >
  >
  > >
  > > Hello all,
  > >
  > > 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
  > > 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
  > > investigate. Any/all suggestions welcome.
  > >
  > > Here's some info on the current configuration:
  > > OS: NT (sp5)
  > > Oracle8 Enterprise Edition 8.0.4.2.0 - Very Large
  > Memory (VLM)
  > > 512M RAM
  > > Running in NOARCHIVELOG mode
  > >
  > > compatible = 8.0.4.0.0
  > > db_block_buffers = 3200
  > > db_block_size = 8192
  > > optimizer_mode = CHOOSE
  > > processes = 200
  > > shared_pool_size = 12000000
  > > sort_area_size = 65536
  > > 25 rollback segments
  > > --
  > > Author: McGlaughlin,Stewart
  > > INET: mcglaughlin_at_attws.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).
  >
  > --
  > Author: Tom Pall
  > INET: tom_at_cdproc.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).
  

  ---

Place4oracle
http://www.geocities.com/place4oracle/

---

Received on Fri Sep 01 2000 - 01:24:37 CDT