Title: RE: UNDO RETENTION
Having had frustration with rollback segments from time to time over the years I am happy to let Oracle handle it with their recommended automatic undo management and a defined undo tablespace. However, it isn't that simple is it? I imagine that undo retention
v$undostat has a maxquerylen column - thats a good
starting point in terms of avoiding ora-1555's if
that's your primary concern
hth
connor
--- [EMAIL PROTECTED] wrote: Having had
frustration with rollback segments from
time to time over the
years I am happy to let Oracle handle it with
Paula - Oracle has added a new table in 9i to help your analysis. V$UNDOSTAT
has a column MAXQUERYLEN that lists the longest query time, and can provide
a guide. SSOLDERRCNT column counts the number of snapshot too old errors in
a time period. In theory this should assist you in deciding whether