You can change the next extent size with an alter table command.
Liz
Elizabeth Reen
CPB Database Group Manager
718.248.9930 (Office)
Service Now Group: CPB-ORACLE-DB-SUPPORT
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Paul Houghton
Sent: Thursday, December 21, 2017 7:06 AM
To: Oracle-L Freelists
Subject: Expanding a table
We are finding ourselves in a situation where a number of sessions conflict on
HW Contention (50 minutes per hour) on a number of tables.
This is a data conversion running in parallel. The problem stems from a
decision to use APIs designed for interactive programs, so we have a slow row
by row conversion which we are attempting to speed up by running it in
parallel. I can't change this decision - I tried!.
I suspect if the table were created at the correct size to start with this
would no longer be an option.
Unfortunately the tables are created by an application (PeopleSoft) which
doesn't allow the initial extent to be specified per table. You can't change
the initial extent once the table has been created, even if the segment hasn't
been created (We have deferred segment creation).
I am thinking I need to try to do something clever with dbms_metadata.get_ddl
to get the definitions, alter them, then drop and recreate the tables.
Can you think of another (easier) way to increase the size of a tables? There
are hundreds of them, so I don't really want to insert loads of rows then
delete them.
Thanks
PaulH
--
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwIFAg&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=53bPIOlcEiirXwZKnhoPO-sihX9NkhnkSLoC3EviWLc&s=kAU6Moq2m9R40NEC4i08Bqx5q80F-hO8IusUK_eCzyk&e=
--
//www.freelists.org/webpage/oracle-l