By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,702 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,702 IT Pros & Developers. It's quick & easy.

What is the best way to change Extent Size

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/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.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.