Database Utilities (MOSC)

MOSC Banner

system table_spce issue on 12c database

edited Mar 12, 2018 11:38AM in Database Utilities (MOSC) 11 commentsAnswered ✓

Hi Team,

the system tablespace is too large and eating the space more on the below database, also some tables and indexes are having more size(600GB).

Kindly provide us with necessary maintenance steps that can be taken to reduce the space

DB release-->12.1.0.2.0

OS->linux

Some of the objects:

325.3134765625 ARGUMENT$ TABLE

246.2646484375 I_ARGUMENT1 INDEX

195.96484375 I_ARGUMENT2 INDEX

57.6220703125 IDL_UB1$ TABLE

27.91015625 SOURCE$ TABLE

11.54296875 IDL_UB2$ TABLE

6.5673828125 I_SOURCE1 INDEX

5.939453125 C_TOID_VERSION# CLUSTER

3.939453125 IDL_CHAR$ TABLE

3.6953125 HEATMAP SYSTEM STATISTICS

Thanks

Ravi Teja K

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center