My knowledge on this issue is as follows:
In Oracle, extent management is performed upon demand, and at any time, the
database tables' extents can be placed in any order. The only exception
comes with Oracle8i, for the tablespaces with the property 'locally
managed', in which tablespace and the tables inside it are in fixed extents.
In UDB, for system maneged tablespaces every database table is written into
different files. For database managed tablespaces, if I remember, the
situation is similar to Oracle case.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Price, Jeff (EDS)
Sent: Tuesday, March 20, 2001 5:00 PM
To: [EMAIL PROTECTED]
Subject: RE: DB2EUG: Question about Tablespace architecture
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.
> -----Original Message-----
> From: Daniel Scheibli [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 3:04 AM
> To: [EMAIL PROTECTED]
> Subject: DB2EUG: Question about Tablespace architecture
>
>
> Hi folks,
>
> today I talked with an Oracle guy and in this
> conversation and interesting question came up:
>
> If we have 2 tables in one tablespace, are
> there any rules how the pages of the tables
> are organized? Are they grouped like AAAABBBB
> or are they written on demand like maybe AABABBAB?
>
> Has anyone the solution or where to find such
> informations?
>
> Thanks in adavanced
>
>
> Daniel
>
> --
> Daniel Scheibli
> Karlsruhe, Germany
>
> Sent through GMX FreeMail - http://www.gmx.net
>
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
