Oracle Database Discussions

Good evening (or morning),

I'm reading the Oracle Concepts (I'm new to Oracle) and it seems that, based on the way that Oracle allocates and manages storage the following premise would be true:

Premise: A table that is often accessed using a full table scan (for whatever reasons) would best reside in its own dedicated tablespace.

The main reason I came to this conclusion is that when doing a full table scan, Oracle does multiblock I/O, likely reading one extent at a time. If the Tablespace's datafile(s) only contain data for a single table then a serial read will not have to skip over segments that contain data for other tables (as would be the case if the tablespace is shared with other tables). The performance improvement is probably small but, it would seem that there is one nonetheless.

I'd like to have the thoughts of experienced DBAs regarding the above premise.

Thank you for your contribution,

John.