Re: How to size UNDO for a database?
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: "dbaorapps@xxxxxxxxx" <dbaorapps@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 25 Mar 2013 19:21:01 -0700 (PDT)
http://dfitzjarrell.wordpress.com/2008/02/22/the-dreaded-ora-01555/
David Fitzjarrell
________________________________
From: Apps DBA <dbaorapps@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
