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

SQL> sho parameter undo;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
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
Tablespaces
Object Type

Search
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
Actions
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
BlackSwan
Messages: 21955
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
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: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use EM, the only tool you need is SQL*Plus.

Regards
Michel
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: 4091
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:
http://www.oracle.com/pls/db121/master_index?letter=a


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


Current Time: Sun Apr 20 20:04:40 CDT 2014

Total time taken to generate the page: 0.05990 seconds