sql blocking problem.

From: ÀÌ¿µÇÑ <hotyoung_at_netnsec.com>
Date: Wed, 10 Jul 2002 05:37:18 GMT
Message-ID: <iKPW8.100855$nP6.10413185@news.bora.net>

I made homepage counter with Oracle.

Action of counter is executed to SQL statement such as lower part.

update t_count set work_date = '20020710', visit_cnt = visit_cnt+1

This program is made with Pro*C. After execute above SQL statement, execute commit statement.

By the way ..

At the same time, in case of program that execute above SQL statement ran much, above SQL is not processed in Oracle and phenomenon that become blocking happens.

How can i solve this problem?

please~~~ help.. me.. Received on Wed Jul 10 2002 - 00:37:18 CDT