數(shù)據(jù)庫(kù)很多表頻繁報(bào)錯(cuò) ora-01688 ora-01650 等錯(cuò)誤 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 add one or more files to the specified tablespace. 從原因上看 unable to extend 是因?yàn)闆](méi)有鄰近的空間可以去擴(kuò)展 報(bào)錯(cuò)的是motorola表空間
首先！我的所有表的next 都是1m pctincrease 0
所以我就先去查motorola 所在表空間最大的鄰近空間 sql>select max(bytes) from dba_free_space where tablespace_name = 'motorola';
max(bytes) ---------- 2126503936
這個(gè)結(jié)果明顯比表的設(shè)置 next extent= 1024k 要大 那我們看看rpt_mot_cell_per的參數(shù)
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';
