Fragmentation in Oracle LMTS tablespace!

Recently two customers reported independent from each other that their LMTS/ASSM tablespace shows much “fragmentation”. What they meant was, that the repeatedly got errors like: ORA-1688: unable to extend table SAPWBP./BIC/B0000256000  partition /BIC/B00002560000000000092 by 128 in tablespace PSAPBWP or ORA-1654: unable to extend index SAPWBP.BALHDR~2 by 128 in tablespace PSAPBWP The errors occurred although there had … Continue reading Fragmentation in Oracle LMTS tablespace!