Why does it take longer to load identical data into 2 identical tables/

I have two identical Oracle tables.  Table A was created as a "create table as...where 1=0" from Table B.  Table B was truncated prior to inserting the data into it.

Each have the same fields, indexes and belong to the same tablespace.  Table B has about half of the empty blocks as Table A.

When a user runs process XYZ to load data into either table, the insert takes way longer for Table B than it does for Table A.  

Why?
cbetterAsked:
Who is Participating?
 
Franck PachotConnect With a Mentor Commented:
Hi,

I see no obvious reasons. You can run:

    ALTER SESSION SET EVENTS '10046 trace name context forever, level 8';
    you insert query
    ALTER SESSION SET EVENTS '10046 trace name context off';

then tkprof the dump file and you will see where the time is spent.


Regards,
Franck
0
 
jerrypdCommented:
it sounds as if table B is fragmented, and is looking for space to put the data maybe?
0
 
cbetterAuthor Commented:
How can you tell if it's fragmented?  We're using ASM.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.