Re: Data Base running too fast ???

I have something similar before. It is from a vendor application. There is a primary constraint on a date field. When the user enter the data, the data will be entered into the database sequentially. And some of the data got bounced out for no reason. I read through all the errors and do some query and find out that all those data who got bounced out had the exact same time (but different content!), and they are complaining that the database is too "fast" also. I basically just tell them to ask their developer to do something about this situation then for me to "tune it slower!"

Winnie

Chris Royce <Chris_at_Royce.net> on 06/13/2000 12:50:43 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

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).