My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.