OraFAQ Forum: Server Administration » Undo management query?

Home » RDBMS Server » Server Administration » Undo management query? (OEL Linux 4.5 ,Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Undo management query? [message #458795]

Tue, 01 June 2010 22:21

elangoealngos
Messages: 7
Registered: May 2010
Location: Chennai

Junior Member

Our UNDO space remains at a high level 85 to 95 percent. We keep adding database files and it doesn't seem to go down significantly. When we do a backup of the system where we shut the database down, it does go down some but then within a week or so it is back up again. How can I figure out what is causing this spike? Any suggestions on how to troubleshoot other than addiding more datafiles

Plese suggest me

Report message to a moderator

Re: Undo management query? [message #458797 is a reply to message #458795]

Tue, 01 June 2010 22:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> Any suggestions on how to troubleshoot other than addiding more datafiles

The only problem is the one between your ears.

STOP making changes when you do not understand the consequences.

What is the benefit of having totally unused space in UNDO tablespace?

Oracle can & does REuse UNDO space containing changes after COMMIT

Only be concerned about UNDO after actual error is thrown.

Report message to a moderator

Re: Undo management query? [message #458809 is a reply to message #458797]

Tue, 01 June 2010 23:27

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Free space in UNDO is just wasted space. UNDO tablespace be used at 100%.

Regards
Michel

Report message to a moderator

Previous Topic:	default users in oracle 9i
Next Topic:	Unable to extend the tablespace ORA-01688

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 13:15:23 CDT 2025