Database Administration (MOSC)

MOSC Banner

SYSTEM tablespace growing large

edited Feb 14, 2014 4:49AM in Database Administration (MOSC) 5 commentsAnswered ✓

I noticed that my SYSTEM tablespace has grown large. I also noticed there are 2 segments SYS_LOB0008305633C00005$$ and SYS_LOB0008305633C00006$$ 1 GB each.

Why are these 2 segments and how can I reduce their size. Of course recreating the database would fix the problem but I wonder if there is another way.
Thanks

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