471,049 Members | 1,406 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

table record distribution query.

How does oracle distribute records in a table that is in a tablespace
with multiple datafiles.

Very simplisticly Ingres will distribute sequential records evenly
across multiple datafiles for a single table. (Not exact but good
enough for this question.)

How does oracle distribute records for a table that is in a tablespace
with multiple datafiles.

Any pointer to where in the documentation this is explained would also
be appreciated.

Many thanks

Paul
Jul 19 '05 #1
1 3143
pa*********@hotmail.com (Paul Hallam) wrote in message news:<5e**************************@posting.google. com>...
How does oracle distribute records in a table that is in a tablespace
with multiple datafiles.

Very simplisticly Ingres will distribute sequential records evenly
across multiple datafiles for a single table. (Not exact but good
enough for this question.)

How does oracle distribute records for a table that is in a tablespace
with multiple datafiles.

Any pointer to where in the documentation this is explained would also
be appreciated.

Many thanks

Paul


Paul, Oracle distributes rows based on the free list whose membership
is determined by interaction of the table settings for pctfree and
pctused with DML activity. See the Concepts manual for details.

Oracle distributes extents accross the files in a tablespace based on
a whole slew of factors: tablespace space management scheme, free
space availability, next extent size requested, etc....

But if you load an empty tablespace one table at a time you can watch
Oracle stripe the extents for a large enough object accross the files
that make up the tablespace. Oracle does not attempt to rebalance
objects that are unevenly distributed or when new files are added to
the tablespace (as DB2 does).

Once a tablespace is loaded the availability of free space extents
sufficient to hold the requested allocation is the primary driver of
where an extent is allocated in conjuction with the tablespace space
management scheme: uniform extents, autoallocate, or dictionary
managed.

HTH -- Mark D Powell --
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Lennart Anderson | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.