Re: Oracle very slow.

Out of your posting, I can't tell why your database uses all of the CPU. More details would be needed here; e.g. is it one of the Oracle background processes, a user background process, a front-end process or what?

For your procedures, it sounds like your are in a long "polling" loop. You may consider using *signals* instead (via DBMS_ALERT). Why do you need to have it as a C program anyway ?

Hope this helps

--
Karl
Oracle Certified DBA

Jeff Wyant wrote in message <69m8ej$3kq$1_at_208.10.2.146>...


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

>