Home » RDBMS Server » Server Administration » Undo management query? (OEL Linux 4.5 ,Oracle 10g)
Undo management query? [message #458795] Tue, 01 June 2010 22:21 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 14:52:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.