ALL DML...
for example:
UPDATE KROPKA.A_PV_DD_PAGES_GEO a SET
a.rozklad_procent =
(SELECT
a.pv_cnt/b.pv_cnt
FROM KROPKA.A_PV_DD_GEO b
WHERE a.d_date_id = b.d_date_id AND a.d_GEO_id = b.d_GEO_id)
WHERE d_date_id=20070730
Użytkownik "Radosław Mańkowski" <radoslaw.mankowski_at_portal.onet.pl> napisał
w wiadomości news:f9mq11$egd$1_at_news.onet.pl...
> Hello,
> On POWER6 I have aix 5306Sp3 and oracle 10.2.0.3.When I run simple DML
> opration on database CPU use 50-100% and has not finished. Truss output
> command on this process:
> kread(0, 0x0000000000000000, 0) (sleeping...)..
>
> do you have any idea why ???
>
Received on Sun Aug 12 2007 - 07:45:42 CDT
