ORA-30036: unable to extend segment by string in undo tablespace- check script

set markup html on spool on
spool db_undo_info.html
set echo on

show parameter undo
select * from v$database;
select * from v$instance;

select tablespace_name, file_id, sum(bytes)/1024/1024 a,sum(maxbytes)/1024/1024 b,autoextensible from dba_data_files where tablespace_name in (select tablespace_name from dba_tablespaces where retention like '%GUARANTEE' )
group by file_id, tablespace_name, autoextensible order by tablespace_name;

select tablespace_name, file_id, bytes/1024/1024/1024,maxbytes/1024/1024/1024,autoextensible,STATUS,ONLINE_STATUS from dba_data_files where tablespace_name in (select tablespace_name from dba_tablespaces
where retention like '%GUARANTEE' ) order by tablespace_name;

select count(status) from dba_undo_extents where status = 'UNEXPIRED';
select count(status) from dba_undo_extents where status = 'EXPIRED';
select count(status) from dba_undo_extents where status = 'ACTIVE';

select a.inst_id, a.ksppinm "Parameter",b.ksppstvl "Session Value",c.ksppstvl "Instance Value" from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.inst_id=b.inst_id and b.inst_id=c.inst_id
and a.ksppinm in ('_undo_autotune', '_smu_debug_mode', '_highthreshold_undoretention', 'undo_tablespace','undo_retention','undo_management') order by 2;

select tablespace_name,retention from dba_tablespaces where retention like '%GUARANTEE';

SELECT TO_CHAR(BEGIN_TIME,'MM/DD/YYYYHH24:MI:SS')BEGIN_TIME, MAXQUERYLEN,TUNED_UNDORETENTION FROM V$UNDOSTAT;

select * from v$undostat order by begin_time;

select tablespace_name, retention from dba_tablespaces where tablespace_name = (select value from v$parameter where name = 'undo_tablespace');

select file_name, autoextensible from dba_data_files where tablespace_name = (select value from v$parameter where name = 'undo_tablespace');

select value from v$parameter where name = 'undo_management';

select value from v$parameter where name = 'undo_retention';

select autoextensible from dba_data_files where tablespace_name=(select value from v$parameter where name = 'undo_tablespace');

select status,count(*),tablespace_name from dba_rollback_segs group by status,tablespace_name;

select sum(bytes) "UNEXPIRED BYTES" from dba_undo_extents where

tablespace_name=(select value from v$parameter where name = 'undo_tablespace') and status='UNEXPIRED';

select sum(bytes) "EXPIRED BYTES" from dba_undo_extents where tablespace_name=(select value from v$parameter where name = 'undo_tablespace') and status='EXPIRED';

SELECT DISTINCT STATUS, SUM(BYTES), COUNT(*) FROM DBA_UNDO_EXTENTS GROUP BY STATUS;

select avg(maxquerylen) from DBA_HIST_UNDOSTAT;
select avg(maxquerylen) from v$UNDOSTAT;

select max(maxquerylen),max(tuned_undoretention) from v$undostat;
select max(maxquerylen),max(tuned_undoretention) from DBA_HIST_UNDOSTAT;

select sum(bytes) from dba_free_space where tablespace_name=(select value from v$parameter where name = 'undo_tablespace');

select * from dba_tablespace_usage_metrics where TABLESPACE_NAME = (select value from v$parameter where name = 'undo_tablespace');

set pagesize 25
set linesize 100
column UNXPSTEALCNT heading "# Unexpired|Stolen"
column EXPSTEALCNT heading "# Expired|Reused"
column SSOLDERRCNT heading "ORA-1555|Error"
column NOSPACEERRCNT heading "Out-Of-space|Error"
column MAXQUERYLEN heading "Max Query|Length"
select inst_id, to_char(begin_time,'MM/DD/YYYY HH24:MI') begin_time,
UNXPSTEALCNT, EXPSTEALCNT , SSOLDERRCNT, NOSPACEERRCNT, MAXQUERYLEN, TUNED_UNDORETENTION
from gv$undostat
order by inst_id, begin_time;

spool off
set markup html off

Thanks for the visit !

 Any doubts or correction/suggestions, please comment below it helps me to improve in further posts.