Run explain plan on it to see if any indexes are used. How many rows are
in the existing table?



>>> Cindy Han <[Email Address Removed] 03/29/02 11:50AM >>>
Hi, List

I have friend the running into this strange problem with his database
server
( EMC, Raid 5, 4CPU, 2 G Memory, Oracle 7.3.4).
The simple update statement update long column option_setting with
approximate 17K data (see below) take 42 seconds.
The more data it update, the slow it get. What can he do to improve
the
performance.

update user_profile set option_setting = :1
where
user_id ='JL' and ui_object ='uo_1::dw_2::dw_case_t_list' and
ui_application ='TEST*PLAN' and ui_option_name ='columns'


call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
----------
Parse 1 0.00 0.00 0 0 0
0
Execute 1 0.00 41.58 9 9 45
1
Fetch 0 0.00 0.00 0 0 0
0
------- ------ -------- ---------- ---------- ---------- ----------
----------
total 2 0.00 41.58 9 9 45
1

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 16

The more data it update, the slow it get. What can he do to improve
the
performance ?


Thanks


Oracle LazyDBA home page