30036ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'解决办法

解决该问题分三步走

（一）
--查看undo表空间使用情况
--插入 和 删除操作才产生对undo空间使用
select  s.username,  s.sid,       rn.name,     rs.extents
                 ,rs.status,  t.used_ublk,  t.used_urec, round(t.used_ublk*8/1024,1) as "SIZE(MB)"
                 ,do.object_name
          from    v$transaction   t
                 ,v$session       s
                 ,v$rollname      rn
                 ,v$rollstat      rs
                 ,v$locked_object lo
                 ,dba_objects     do
          where  t.addr        = s.taddr
          and    t.xidusn      = rn.usn
          and    rn.usn        = rs.usn
          and    t.xidusn      = lo.xidusn(+)
          and    do.object_id  = lo.object_id
         
（二）
--锁解决方法
select b.owner,b.object_name,l.session_id,l.locked_mode
from v$locked_object l, dba_objects b
where b.object_id=l.object_id

select t2.username,t2.sid,t2.serial#,t2.logon_time 
from v$locked_object t1,v$session t2 
where t1.session_id=t2.sid order by t2.logon_time

--查看对应执行的SQL
select sql_text from v$sqltext where address in(select sql_address from v$session where sid=&sid)order by piece


（三）
--kill session
alter system kill session 'sid,serial#'

--如果上面KILL不行则需要在os级进行进程切断
select spid from v$session s ,v$process p where p.addr=s.paddr and s.sid=&sid

--oracle用户下执行如下命令
kill -9 &spid