Dear Jeff,
thanks for your answer. I think my question was not that good. The Oracle
guy
told me that what you are writing, but I don't know how it is in UDB.
In UDB we have our pages and tablespaces with containers. The term extends
allows use to configure the number of pages after that the switch to the
next
container will be done.
But my question was the following: Think of we have a UDB database with the
a
tablespace containing table A and B. Then we have a application inserting
new
records to table A and second application inserting new records to table B.
Is there
a order in which the pages are written to the tablespace? In Oracle there is
a
grouping of the blocks because of the extends, but how is in in UDB?
Thanks in advanced
Daniel
> price, Jeff (EDS) wrotes:
> Daniel:
> Since you were talking to an Oracle guy, I assume you are asking about
Oracle.
> In Oracle pages are called "blocks". When Oracle allocates space to an
object,
> it does so in extents, which are multiple contiguous blocks. The size of
the extent
> is dependent upon the size indicated in the "initial" and "next"
parameters. Each
> tablespace can have a default value for these parameters for all segments
that get
> allocated to it, or a segment may specify its own "initial" and "next"
size to override
> the tablespace default size (if present).
> To answer your question: If each letter "A" is an extent (# of contiguous
blocks
> for table-A) and each letter "B" an extent for table-B, then both
scenarios (AAAABBBB
> or AABABBAB) are possible depending on how/when the tables are populated.
I believe
> that the smallest extent in Oracle is five database blocks.
> Hope this helps.
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.de
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
