SELECT inst_id, to_char(begin_time,'MM/DD/YYYY HH24:MI') begin_time, UNXPSTEALCNT "Unexpired Stolen", EXPSTEALCNT "Expired Reused",
SSOLDERRCNT "Snapshot err", NOSPACEERRCNT "Out of space err",
MAXQUERYLEN, tuned_undoretention
FROM gv$undostat
WHERE begin_time between to_date('
ORDER BY inst_id, begin_time;
Problem 1: Out of space error and unexpired extents are stolen
Solution : Increase the undo Tablespace size.
Problem 2: Snapshot error and Expired extents are reused
Solution: Increase the undo Retention
Thanks
No comments:
Post a Comment