Re: oracle and aix problem

On Sun, 12 Aug 2007 14:45:42 +0200, "Radosław Mańkowski" <radoslaw.mankowski_at_portal.onet.pl> wrote:

>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

You did look at the EXPLAIN PLAN for this statement? kread is just an asynchronous read. If your asynchronous read doesn't complete, this is not necessarily an Oracle problem.

--
Sybrand Bakker
Senior Oracle DBA