Thursday, April 9, 2009

Tuning Undo - Part 1

Execute the following query,

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('','MM/DD/YYYY HH24:MI:SS')and to_date('','MM/DD/YYYY HH24:MI:SS')
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:

Followers

Powered By Blogger
 

Oracle Database Administration. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com