1 Reply Latest reply: Dec 4, 2013 9:41 AM by EdStevens RSS

    simple question about block splitting

    NightWing

      Hello Experts,

       

      My question is, aren't the following DML performing 90-10 block split?? Because it has been said that the first one performs 50-50 block splitting.

       

      SQL> CREATE TABLE album_sales_IOT(album_id number, country_id number, total_sals number, album_colour varchar2(20),

           CONSTRAINT album_sales_iot_pk PRIMARY KEY(album_id, country_id)) ORGANIZATION INDEX;

       

      Table created.

       

      1

       

      SQL> BEGIN

       

        2    FOR i IN 5001..10000 LOOP

        3      FOR c IN 201..300 LOOP

        4        INSERT INTO album_sales_iot VALUES(i,c,ceil(dbms_random.value(1,5000000)), 'Yet more new rows');

        5      END LOOP;

        6    END LOOP;

        7    COMMIT;

        8  END;

        9  /

       

      PL/SQL procedure successfully completed.

       

       

      1

      2

      3

      4

      5

      6

      7

      8

      9

      10

      11

       

      SQL> BEGIN

       

        2    FOR i IN 1..5000 LOOP

        3       FOR c IN 101..200 LOOP

        4          INSERT INTO album_sales_iot

        5          VALUES(i,c,ceil(dbms_random.value(1,5000000)), 'Some new rows');

        6       END LOOP;

        7    END LOOP;

        8    COMMIT;

        9  END;

      10  /

      PL/SQL procedure successfully completed.