Oracle very slow.

[Quoted] We are in a conversion from a sybase database to an oracel database. I've noticed that in the Oracle database is using all of the CPU while the Sybase database used very little of the CPU. We are running this on an HP/Unix machine. This system is for recording data from our shop floor (We manufacture Television Tubes). The way it is setup is a C program executes a stored procedure called Read_buffer. This procedure calls Facts_update. This procedure looks at the record ID to decide which stored procedure to call. There is a seperate stored procedure for

each ID. This final stored procedure updates the database. The first stored procedure Read_buffer is in a loop. When there is no data to update I call the DBMS_LOCK.SLEEP package to put the routine to sleep. I've got the feeling this is not the thing to do. I was hoping this would put the routine into a wait state in the computer. Does anyone have experence in running stored procedures in a loop for long periods of time? This setup will run for months without exiting the Read_buffer routine. Any opinion will be appreciated. Thanks. Received on Fri Jan 16 1998 - 00:00:00 CET