Home » RDBMS Server » Server Administration » does increase in UNDO tablespace size affect the db?
does increase in UNDO tablespace size affect the db? [message #212384] Fri, 05 January 2007 01:43 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi all

We are using Oracle 10g,
SGA size= 1000MB

Recently i have increased the size of the undo tablespace from 400MB to 800MB.

What kind of affect the above change will cause to the database.

Thanks

Re: does increase in UNDO tablespace size affect the db? [message #212418 is a reply to message #212384] Fri, 05 January 2007 04:39 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
UNDO_RETENTION is what matters in most of the cases.
It depends on your application and nothing to do with SGA size.
Search this forum for UNDO_RETENTION
Previous Topic: what does quiesce do ? how its different from restricted session ?
Next Topic: Issue in v$logmnr_contents
Goto Forum:
  


Current Time: Fri Dec 09 13:56:07 CST 2016

Total time taken to generate the page: 0.06968 seconds