What is the best way to change Extent Size

[jcgeorge]

I would like to perform a redirected restore and was wondering what is
the best way to migrate all the data & strucuture but to modify the
original extent size of the tablespaces. The tablespaces were
originally setup with an inadequate extent size and now we are trying
to have the extent size at least match the RAID5 stripe size.

I would hate to have to restore the DB (redirect) and then move/copy
all the tables to newly created tablespaces. I will need to perform
this against at least 12 (PeopleSoft) databases with thousands of
tables.

Thanks in advance.

John George

[Mark A]

<jc******@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

I would like to perform a redirected restore and was wondering what is
the best way to migrate all the data & strucuture but to modify the
original extent size of the tablespaces. The tablespaces were
originally setup with an inadequate extent size and now we are trying
to have the extent size at least match the RAID5 stripe size.

I would hate to have to restore the DB (redirect) and then move/copy
all the tables to newly created tablespaces. I will need to perform
this against at least 12 (PeopleSoft) databases with thousands of
tables.

Thanks in advance.

John George

It is unlikely that your extent size is less than your stripe size (although
not impossible). Remember that if your stripe size is 64K, then an extent
size of 16 is actually 64K (for a 4K tablespace page size), which is a 1
times the stripe size (this is acceptable because it is a even multiple).

Higher extent sizes (higher multiples) are more important for decision
support systems where there are a lot of tablespace scans, and not so
important for OLTP systems where most access is via an index.