This discussion is archived
1 Reply Latest reply: Dec 4, 2013 7:41 AM by EdStevens RSS

simple question about block splitting

NightWing Journeyer
Currently Being Moderated

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.