Database many tables frequent error ora-01688 ORA-01650 errors such as ORA-01650: unable to extend rollback segment% s by% s in tablespace% s Cause: Failed to allocate extent for the rollback segment in tablespace Action:. Use the ALTER TABLESPACE Add DataFile Statement to The specified tablespace. Unable to extend is because there is no neighboring space to expand an error is Motorola table space.
First of all! NEXT of all my tables is 1M PctinCrease 0
So I will first checked the largest neighboring space SQL> select max (bytes) from dba_free_space where tablespace_free = 'motorola';
Max (Bytes) ---------- 2126503936
This result is clear than the setting of the table next eXtent = 1024K. We look at the parameters of RPT_MOT_CELL_PER.
Select next_extent, PCT_INCREASE, TABLESPACE_NAME from DBA_TAB_PARTITIONS WHERE Partition_Name = 'p9' and table_owner = 'MOT_NMC' AND TABLE_NAME = 'RPT_MOT_CELL_PER';
NEXT_EXTENT PCT_INCREASE ---------------------- TableSpace_name ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------ 1048576 0motorola
Solutions on Metalink: 1.alter TableSpace Motorola coalesce;
The extents must be adjacent to each other for this to work I have used! No use 2 add datafile or resize is obvious! Later, I also had an effect after adding data documents!
3. Modify next this is also valid.
Later I found out that my idea had a problem.
The earlier maximum extent is not used!
SELECT Count (*) from dba_free_space where tablespace_name = 'motorola'; --------
47212
SELECT Count (*) from dba_free_space where tablespace_name = 'motorola'and bytes <1048576; --------
47208
Most of Extents are small and 1M, so they can't allocate Oracle will not go to the biggest!