DWH Tablespace Issue UNDO Table No Space Free
(Doc ID 2902787.1)
Last updated on MARCH 13, 2024
Applies to:
Oracle Communications Performance Intelligence Center (PIC) Software - Version 10.0.0 and laterInformation in this document applies to any platform.
Goal
Question
-----------------
The tablespace UNDO table no space free (100% used) in DWH
$ ./ViewTbspceUsage.sh
Tablespace Used (Mb) Max (Mb) Used %
------------------------------ ------------- ------------- ----------
DATA_CDR 211656 2621440 8
DATA_CONF 7 2048 0
DATA_IND 131839 2342912 6
DATA_LOG 25 2048 1
SYSAUX 1135 65536 2
SYSTEM 667 65536 1
UNDO 262144 262144 100
OCPIC version 10.4.0.4
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |