Performace question

From: music4 <music4_at_163.net>
Date: Fri, 14 Jan 2005 22:11:14 +0800
Message-ID: <cs8ju8$qtj@netnews.proxy.lucent.com>

Greetings,

My program access Oracle database via OCI. But today I found a strange that a Oracle process occupy more than 10% CPU usgae, and IOWAIT is also higher than 10%. Then I found the Oracle process always access table A. Then I use sqlplus to check "select count(*) from table_a", it took several seconds, but there were only less then 10 records in it. After I do a "truncate table table_a", the Oracle process's CPU usage get down to less than 2% and IOWAIT get down to less then 1%.

Could you please figure out why that happened, and how to solve the problem without truncate table. (Since I could not perform truncate at real in-service site.)

Thanks in advance!
Evan Received on Fri Jan 14 2005 - 08:11:14 CST