| System undo segments [message #170418] |
Wed, 03 May 2006 12:37  |
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
|
Member |
|
|
Hi
Currently my instance is having rollback segments but due to an upgrade I have to switch to SMU
Could you please ptovide me step by step instruction to convert to SMU
Also
select tablespace_name ,sum(bytes/1024/1024) from dba_data_files where tablespace_name in ( select tablespace_name from dba_rollback_segs) group by tablespace_name;
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
RBS 17740
SYSTEM 10500
select SEGMENT_NAME from dba_rollback_segs;
SEGMENT_NAME
------------------------------
SYSTEM
RBS01
RBS02
RBS03
RBS04
RBS05
RBS06
RBS07
RBS_LARGE
RBS08
RBS09
SEGMENT_NAME
------------------------------
RBS10
RBS11
RBS12
RBS13
RBS14
RBS15
RBS_DATALOAD
What should be the size of SMU.
Puneet
|
|
|
|
| Re: System undo segments [message #170421 is a reply to message #170418] |
Wed, 03 May 2006 12:54  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
SMU=Server Managed Undo?
There is nothing here a 'step-by-step' method.
In 9i and above create a new Undo tablespace. First, you need to understand what UNDO_RETENTION means.
Please search the forum for UNDO_RETENTION.
Edit:
I mean, all you have to do is
create your undotablespace
Shutdown the database *****cleanly*****
do the changes to init.ora
start the database
drop old RBS
Ofcourse before all these, you need to understand what Automatic Undo has to offer.
[Updated on: Wed, 03 May 2006 13:02] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
