10g automatically increasing undo tablespace inorder to reduce snapshot
too old error.




BR//
Majid Yousuf





"Zhang Jean S " <oracledba-ezmlmshield-x30090149.[Email address protected]

28/09/2006 09:31 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
UNDO tablespace behavior in Oracle10gr2







All,

My database was upgraded from Oracle9.2.0.5 to 10.2.0.2, with one month
period, the UNDO tablespace size is doubled and there is not changes in
the application, and it is keeping growing now. Does anybody has any
idea why the UNDO needs more space in oracle10g?

Thanks,
Jean


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





This e-mail and any files transmitted with it are for the sole use of the intended
recipient(s) and may contain confidential and privileged information. If you are
not the intended recipient, please contact the sender by reply e-mail and destroy
all copies and the original message. Any unauthorized review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken
in reliance on this e-mail is strictly prohibited and may be unlawful.The recipient
acknowledges that Bharti Airtel Limited or its subsidiaries and associated companies(collectively "Bharti Airtel Limited"), are unable to exercise control or ensure or guarantee the integrity of/overthe contents
of the information contained in e-mail transmissions and further acknowledges that any views
expressed in this message are those of the individual sender and no binding nature of the
message shall be implied or assumed unless the sender does so expressly with due authority of Bharti Airtel Limited.Before opening any attachments please check them for viruses and defects.

Oracle LazyDBA home page