Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Base running too fast ???

RE: Data Base running too fast ???

From: Guidry, Chris <>
Date: Tue, 13 Jun 2000 14:23:52 -0600
Message-Id: <>

We all wish we had that problem. Unreal.

Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854

> -----Original Message-----
> From: Chris Royce []
> Sent: Tuesday, June 13, 2000 1:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Data Base running too fast ???
> Anyone had problems with a database running too fast. It was a first for
> me. I recently, upon gaining additional disk and memory, was able to
> re-archetect several of my production instances. I also tuned the heck
> out of them and optimized to the maximum that our physical configuration
> would allow.
> One of our 'canned' applications captures employee clock punches at our
> manufacturing plants and sends them to an Oracle database where they are
> processed before going to our HR application. Shortly after the database
> re-org we started encountering duplicate records in a transaction table
> (no unique key constraint). The application Vendor spent a bunch of time
> debugging the problem and it was discovered that the clock punches are
> captured only down to the second and as a result the processing speed of
> our system allows duplicate records when multiple punches are captured.
> Prior to the reorganization this had not been an issue. The Vendor
> complained that the database was too fast !!! Sometimes you can't win.
> We declined to 'slow down' the database and suggested that the onus be
> on them to refine the degree of granularity that the time records are
> captured.
> Much better situation than some of the incredibly interesting disaster
> stories that have appeared lately.
> Chris Royce
> Jamestown NC
> --
> Author: Chris Royce
> 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: (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 Tue Jun 13 2000 - 15:23:52 CDT

Original text of this message