| sizing Undo tablespace [message #168638] |
Fri, 21 April 2006 07:20  |
smriti_pal
Messages: 3
Registered: November 2005
Location: India
|
Junior Member |
|
|
Hi All,
We have to resize the undotablespace in out testing environment
according to the size of rollback segment in Procudtion environment. Production env is Oracle7 and testing env is Oracle9i
IN production max(rssize) is - 31455232 and
SQL> select sum(bytes) from dba_segments where segment_type='ROLLBACK';
SUM (BYTES)
----------
839680000
SQL> select max (bytes) from dba_segments where segment_type='ROLLBACK';
MAX(BYTES)
----------
629145600
1) I do'nt understand y ther is a difference in rssize n bytes of v$rollstat and dba_segments respectively.
2) How to calculate the size
|
|
|
|
|
|
|
|
|
|
| Re: sizing Undo tablespace [message #168654 is a reply to message #168651] |
Fri, 21 April 2006 08:19  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
That is what i was addressing.
You are designing something in 9.x (using undo_retention etc) and expect the same behaviour in 7.x? ( Apart from UNDO, there are many other thingies that vary here). THere is no UNDO_RENTION concept in 7.x. So SIZE is what matters. In 9i, size and undo_retention matters.
[Updated on: Fri, 21 April 2006 08:21] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
