| undo_tablespace - rollback segment OFFLINE [message #229395] |
Sat, 07 April 2007 05:17  |
Brayan
Messages: 315
Registered: June 2002
|
Senior Member |
|
|
Hi,
I have set undo_management and undo_tablespace. When I query dba_rollback_segs, some segments are ONLINE and some are OFFLINE. Is it normal behavior?
SQL> select name, value from v$parameter where name like 'undo_tablespace';
NAME VALUE
------------------------- ------------------------------
undo_tablespace SYS_UNDOTS
SQL> select name, value from v$parameter where name like 'undo_management';
NAME VALUE
------------------------- ------------------------------
undo_management AUTO
SQL>
1 select owner, segment_name, tablespace_name, status from dba_rollback_segs
2* where tablespace_name = 'SYS_UNDOTS'
SQL> /
OWNER SEGMENT_NAME TABLESPACE_NAME STATUS
------ ------------------------------ ------------------------------ ----------------
PUBLIC _SYSSMU1$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU2$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU3$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU4$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU5$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU6$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU7$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU8$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU9$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU10$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU21$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU22$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU23$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU24$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU25$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU26$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU27$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU28$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU29$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU30$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU31$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU32$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU33$ SYS_UNDOTS OFFLINE
23 rows selected.
Brayan
|
|
|
|
|
|
| Re: undo_tablespace - rollback segment OFFLINE [message #229470 is a reply to message #229395] |
Sun, 08 April 2007 13:19  |
 |
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Do you have several undo tablespaces?
Did you switch to another one?
Post the result of:
select owner, segment_name, tablespace_name, status
from dba_rollback_segs
where tablespace_name in (
select tablespace_name from dba_tablespaces where contents='UNDO'
)
/
Did you switch to manual?
Post the result of "show parameter undo".
Regards
Michel
[add the 2 last lines]
[Updated on: Sun, 08 April 2007 13:22] Report message to a moderator |
|
|
|
| Re: undo_tablespace - rollback segment OFFLINE [message #229584 is a reply to message #229470] |
Mon, 09 April 2007 04:53 |
Brayan
Messages: 315
Registered: June 2002
|
Senior Member |
|
|
Hi Michel,
>Do you have several undo tablespaces?
Yes
>Did you switch to another one?
May be yes. This is the setup before I joined.
>select owner, segment_name, tablespace_name, status
>from dba_rollback_segs
>where tablespace_name in ( select tablespace_name from >dba_tablespaces where contents='UNDO');
OWNER SEGMENT_NAME TABLESPACE_NAME STATUS
------ --------------- --------------- ----------
PUBLIC _SYSSMU1$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU2$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU3$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU4$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU5$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU6$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU7$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU8$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU9$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU10$ SYS_UNDOTS ONLINE
PUBLIC _SYSSMU21$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU22$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU23$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU24$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU25$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU26$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU27$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU28$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU29$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU30$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU31$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU32$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU33$ SYS_UNDOTS OFFLINE
PUBLIC _SYSSMU11$ ROLLBACK_TS OFFLINE
PUBLIC _SYSSMU12$ ROLLBACK_TS OFFLINE
PUBLIC _SYSSMU13$ ROLLBACK_TS OFFLINE
PUBLIC _SYSSMU14$ ROLLBACK_TS OFFLINE
PUBLIC _SYSSMU15$ ROLLBACK_TS OFFLINE
PUBLIC _SYSSMU16$ ROLLBACK_TS OFFLINE
PUBLIC _SYSSMU17$ ROLLBACK_TS OFFLINE
PUBLIC _SYSSMU18$ ROLLBACK_TS OFFLINE
PUBLIC _SYSSMU19$ ROLLBACK_TS OFFLINE
PUBLIC _SYSSMU20$ ROLLBACK_TS OFFLINE
>Did you switch to manual?
No
>Post the result of "show parameter undo".
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_suppress_errors boolean FALSE
undo_tablespace string SYS_UNDOTS
Regards,
Ronald.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
