Home » RDBMS Server » Enterprise Manager » undo tablespace issues (Oracle, RedHatLinux-5)
undo tablespace issues [message #592466] Thu, 08 August 2013 12:40 Go to next message
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Sir,
When the following statements executed in sqlplus,

SQL> sho parameter undo;

------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1

here, undo_management showing 'AUTO' where as in EM Database Control below , Segment Space Management showing ' Manual' for the undo tablespace (UNDOTBS1) created, how it is possible?

[Oracle Enterprise Manager]
Setup Preferences Help Logout

Database Instance: tdump > Tablespaces Logged in As SYS
Object Type

Select an object type and optionally enter an object name to filter the data that is displayed in your results set.
Object Name

By default, the search returns all uppercase matches beginning with the string you entered. To run an exact or case-sensitive match, double quote the search string. You can use the wildcard symbol (%) in a double quoted string.
Selection Mode
Select Name [Sorted in ascending order] Size (MB) Used (MB) Used (%) Free (MB) Status Datafiles Type Extent Management Segment Management
SYSAUX 260.0 251.1 [Used (%)] [Used (%)] [Used (%)] 96.6 8.9 [Status] 1 PERMANENT LOCAL AUTO
SYSTEM 480.0 475.9 [Used (%)] [Used (%)] [Used (%)] 99.2 4.1 [Status] 1 PERMANENT LOCAL MANUAL
TEMP 20.0 0.0 [Used (%)] [Used (%)] 0.0 20.0 [Status] 1 TEMPORARY LOCAL MANUAL
UNDOTBS1 105.0 10.2 [Used (%)] [Used (%)] [Used (%)] 9.7 94.8 [Status] 1 UNDO LOCAL MANUAL
USERS 16.2 13.4 [Used (%)] [Used (%)] [Used (%)] 82.7 2.8 [Status] 1 PERMANENT LOCAL AUTO
Total Size (MB) 881.2
Total Used (MB) 750.6
Total Free (MB) 130.6

Online Offline Read Only

Database | Setup | Preferences | Help | Logout
Copyright © 1996, 2005, Oracle. All rights reserved.
About Oracle Enterprise Manager 10g Database Control

Re: undo tablespace issues [message #592468 is a reply to message #592466] Thu, 08 August 2013 12:52 Go to previous messageGo to next message
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

Re: undo tablespace issues [message #592476 is a reply to message #592466] Thu, 08 August 2013 14:32 Go to previous messageGo to next message
Michel Cadot
Messages: 67812
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use EM, the only tool you need is SQL*Plus.

Re: undo tablespace issues [message #592479 is a reply to message #592466] Thu, 08 August 2013 15:56 Go to previous message
John Watson
Messages: 8531
Registered: January 2010
Location: Global Village
Senior Member
You are confusing "automatic undo management" and "automatic segment space management". Look up both terms in the docs, here is a link to the master index:

Previous Topic: OEM 10g to 12c (2 system upgrade process)
Next Topic: copying the user
Goto Forum:

Current Time: Thu Apr 15 06:44:09 CDT 2021