RE: Data Base running too fast ???

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
Email: chris.guidry_at_atcoelectric.com

> -----Original Message-----
> From: Chris Royce [SMTP:Chris_at_Royce.net]
> 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
> INET: Chris_at_Royce.net
>
> 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 Tue Jun 13 2000 - 15:23:52 CDT