How to size UNDO for a database?
From: Apps DBA <dbaorapps_at_gmail.com>
Date: Tue, 26 Mar 2013 00:32:29 +0530
Message-ID: <CAHvOz+zA9GuCWyfLTg9FnbaMN1n9CObKFqSWjXsjtvfvTBgHvw_at_mail.gmail.com>
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.
Date: Tue, 26 Mar 2013 00:32:29 +0530
Message-ID: <CAHvOz+zA9GuCWyfLTg9FnbaMN1n9CObKFqSWjXsjtvfvTBgHvw_at_mail.gmail.com>
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-lReceived on Mon Mar 25 2013 - 20:02:29 CET