How to size UNDO for a database?

  • From: Apps DBA <dbaorapps@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 26 Mar 2013 00:32:29 +0530

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2013