DBMS_REDEFINITION
Oracle 9.2.0.7
Hi,
I have a heap table that contains ~125M rows (avg row len 28) and is just under 5GB in size. I'm looking to move this to an IOT or Cluster to reduce the amount of IO on this table (it accounts for about 30% of the IO on our system). The table holds customer information and the main queries only ever look at one customer at a time, who may have several hundred rows.
I'm looking for the best way to move this table to an IOT, preferably without the need for an outage, so I looked at DBMS_REDEFINITION (this didnt seem to work when trying to redefine to a single table Cluster). I've tested against a small table with 7M rows in a test environment and created an IOT as the staging table, and ran the redefinition - I set parallel dml and query to 4 at session level. However, this took 1hr 30mins to do 7M rows. Obviously our Production environment is more powerfull but the DBMS_REDEFINITION option seems far too slow.
Hi,
I have a heap table that contains ~125M rows (avg row len 28) and is just under 5GB in size. I'm looking to move this to an IOT or Cluster to reduce the amount of IO on this table (it accounts for about 30% of the IO on our system). The table holds customer information and the main queries only ever look at one customer at a time, who may have several hundred rows.
I'm looking for the best way to move this table to an IOT, preferably without the need for an outage, so I looked at DBMS_REDEFINITION (this didnt seem to work when trying to redefine to a single table Cluster). I've tested against a small table with 7M rows in a test environment and created an IOT as the staging table, and ran the redefinition - I set parallel dml and query to 4 at session level. However, this took 1hr 30mins to do 7M rows. Obviously our Production environment is more powerfull but the DBMS_REDEFINITION option seems far too slow.
0