Re: How to size UNDO for a database?
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Mon, 25 Mar 2013 19:21:01 -0700 (PDT)
Message-ID: <1364264461.69317.YahooMailNeo_at_web121602.mail.ne1.yahoo.com>
http://dfitzjarrell.wordpress.com/2008/02/22/the-dreaded-ora-01555/
David Fitzjarrell
From: Apps DBA <dbaorapps_at_gmail.com> To: oracle-l_at_freelists.org
Sent: Monday, March 25, 2013 12:02 PM
Subject: How to size UNDO for a database?
Date: Mon, 25 Mar 2013 19:21:01 -0700 (PDT)
Message-ID: <1364264461.69317.YahooMailNeo_at_web121602.mail.ne1.yahoo.com>
http://dfitzjarrell.wordpress.com/2008/02/22/the-dreaded-ora-01555/
David Fitzjarrell
From: Apps DBA <dbaorapps_at_gmail.com> To: oracle-l_at_freelists.org
Sent: Monday, March 25, 2013 12:02 PM
Subject: How to size UNDO for a database?
Hi Gurus,
I would like to know how to analyze and size undo for a busy database or
while design itself. As the transactions increasing for a busy DB like
reporting or DW DB we usually face lot of jobs failing with snapshot too
old error. Please share your knowledge.
Thanks,
Ann
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 26 2013 - 03:21:01 CET