读undo 导致db file sequential read

db file sequential read:

SQL> select * from v$mystat where rownum<10;

       SID STATISTIC#	   VALUE
---------- ---------- ----------
      1141	    0	       0



SQL> delete from test400;
delete from test400
            *
第 1 行出现错误:
ORA-30036: 无法按 8 扩展段 (在还原表空间 'UNDOTBS1' 中)


SQL> /

已删除2783106行。


select * from v$mystat where rownum<10;
--1719

select count(*) from test400;

select a.session_id,
       a.sql_id,
       a.machine,
       a.blocking_session,
       a.sample_time,
       a.module,
       a.PROGRAM,
       a.event,
       a.p1,
       a.P1TEXT,
       a.p2,
       a.P2TEXT,
       a.P3,
       a.P3TEXT,
       b.SQL_TEXT
  from v$active_session_history a, v$sqlarea b
 where a.sql_id = b.sql_id;



SESSION_ID	1719	
SQL_ID	5yu8jna5gqjhn	
MACHINE	WORKGROUP\TLCB-PC	
BLOCKING_SESSION		
SAMPLE_TIME	10-4月 -19 07.18.39.915 下午	
MODULE	PL/SQL Developer	
PROGRAM	plsqldev.exe	
EVENT	db file sequential read	
P1	7	
P1TEXT	file#	
P2