Re: How to know the problem is overheating in the hardware

Juan,

> The point is, if there is some trick to know if there is a problem
> cause by exposing the server to overheating for some periods, from
> Oracle database.

Wow! And I thought I'd worked on some hot projects! The database sits on the Oracle software which sits on the operating system which sets on the hardware.

   My concern would be whether any invalid data was entered in the database during the time the server was overheating. Talk to the client and see if they can establish the time period when the overheating occurred.

   If I were you, I would think of creative ways to validate the data. Check the maximum and minimum values of each column. If you have strong constraints defined on your schema, that will help prevent invalid data from being stored. Carefully check the data entered during the time period of the overheating.

   When IBM gave their original PC prototype to Microsoft for DOS development, IBM insisted it be put in a secure room which turned out to have inadequate ventilation. So Microsoft left the door open and trained their receptionist to broadcast a coded message on the PA system if IBM representatives showed up for an unannounced inspection.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l