Re: NT performance issues

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 ----- From: McGlaughlin,Stewart <mcglaughlin_at_attws.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, August 30, 2000 12:56 PM Subject: NT performance issues

>
> 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).
Received on Thu Aug 31 2000 - 12:18:13 CDT