recreate table sale(id int primary key, ke int, ddoc int, tid int);
commit;
create index sale_tid on sale(tid);
create descending index sale_ddoc_desc on sale(ddoc);
commit;

SQL> set planonly;
SQL> select
CON>     s.id,
CON>     s.ke,
CON>     s.ddoc,
CON>     sum(s.ke) over(order by s.ddoc desc) as ostatoknadatu
CON> from sale s
CON> where s.tid = 1005
CON> order by s.ddoc desc;

PLAN  SORT  ( SORT  (S INDEX (SALE_TID)))
SQL> set explain on;
SQL> select
CON>     s.id,
CON>     s.ke,
CON>     s.ddoc,
CON>     sum(s.ke) over(order by s.ddoc desc) as ostatoknadatu
CON> from sale s
CON> where s.tid = 1005
CON> order by s.ddoc desc;

Select Expression
    -> Sort (record length: 60, key length: 8)
        -> Window
            -> Record Buffer (record length: 65)
                -> Sort (record length: 68, key length: 8)
                    -> Window
                        -> Record Buffer (record length: 33)
                            -> Filter
                                -> Table "SALE" as "S" Access By ID
                                    -> Bitmap
                                        -> Index "SALE_TID" Range Scan (full match)

CREATE TABLE MOVEMENTS (
 GOOD INTEGER NOT NULL REFERENCES GOODS,
  MOVEMENT_DTS TIMESTAMP ,
 AMOUNT INTEGER NOT NULL);

CREATE TABLE GOODS_AMOUNTS_AGG (
  GOOD INTEGER NOT NULL REFERENCES GOODS,
   SNAPSHOT_HOUR INT ,
  AMOUNT INTEGER NOT NULL);

CREATE PROCEDURE GOODS_AMOUNT_ROLL_UP AS
DECLARE GOOD INTEGER;
DECLARE TOTAL INTEGER;
 DECLARE SNAPSHOT_HOUR INT; 
BEGIN
    FOR 
        SELECT GOOD,  DATEDIFF(HOUR FROM TIMESTAMP '01.01.2015' TO MOVEMENT_DTS) ,  SUM(AMOUNT) 
        FROM  GOODS_AMOUNT_AGG 
        GROUP BY GOOD,  DATEDIFF(HOUR FROM TIMESTAMP '01.01.2015' TO MOVEMENT_DTS) 
        HAVING COUNT(*)>1
    INTO :GOOD,  :SNAPSHOT_HOUR , :TOTAL 
    DO
    BEGIN
       DELETE FROM GOODS_AMOUNT_AGG 
       WHERE GOOD=:GOOD AND  DATEDIFF(HOUR FROM TIMESTAMP '01.01.2015' TO MOVEMENT_DTS) = :SNAPSHOT_HOUR ;
       INSERT INTO GOODS_AMOUNT_AGG (GOOD,  SNAPSHOT_HOUR , AMOUNT) 
       VALUES(:GOOD,  :SNAPSHOT_HOUR , :TOTAL);
    END
END