Home » RDBMS Server » Server Administration » Undo Tablespace
Undo Tablespace [message #299160] Sun, 10 February 2008 04:09 Go to next message
lselva21
Messages: 8
Registered: November 2007
Location: Kuala Lumpur
Junior Member

Hi All,

Can someone let me know what the major impact of UNDO Tablespace?
I have clone the PRD DB to TEST DB which SGA size of TEST is lesser than PRD DB.
Now the problem problem is i'm getting "Snapshot Too Old" in TEST DB if DML statement executed. FYI Undo TBS for TEST is higher than PRD DB but retention period same.

Please let me know what could be the problem. Thanks
Re: Undo Tablespace [message #299167 is a reply to message #299160] Sun, 10 February 2008 05:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Always post your Oracle version (4 decimals).
UNDO tablespace behaviour changes with version.

When you don't understand something try Database Concepts, 95% of your questions are answered there.

Regards
Michel

[Updated on: Sun, 10 February 2008 05:19]

Report message to a moderator

Re: Undo Tablespace [message #299179 is a reply to message #299167] Sun, 10 February 2008 06:41 Go to previous messageGo to next message
lselva21
Messages: 8
Registered: November 2007
Location: Kuala Lumpur
Junior Member

Thanks Michel..

But both DB is same version Oracle9i Enterprise Edition Release 9.2.0.6.0 .

Thanking in advance.
Re: Undo Tablespace [message #300258 is a reply to message #299167] Thu, 14 February 2008 15:10 Go to previous messageGo to next message
itguru
Messages: 19
Registered: July 2007
Junior Member

UNDO tablespace behaviour changes with version. !!!!!!!!!



Is it ????????????????????


Michel Cadot wrote on Sun, 10 February 2008 05:18
Always post your Oracle version (4 decimals).
UNDO tablespace behaviour changes with version.

When you don't understand something try Database Concepts, 95% of your questions are answered there.

Regards
Michel


Re: Undo Tablespace [message #300306 is a reply to message #300258] Thu, 14 February 2008 23:30 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
UNDO tablespace behaviour changes with version. !!!!!!!!!
Is it ????????????????????
¨
It may as for all other components, Oracle tries to improve them at each version.

Regards
Michel
Previous Topic: ORA-01041: internal error. hostdef extension doesn't exist
Next Topic: Udump Error Defination
Goto Forum:
  


Current Time: Sun Dec 04 17:05:37 CST 2016

Total time taken to generate the page: 0.08730 seconds