| undo tablespace issues [message #592466] |
Thu, 08 August 2013 12:40  |
8939513598$
Messages: 103
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
