Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question.

Asked: September 03, 2018 - 2:07 pm UTC

Last updated: September 03, 2018 - 4:06 pm UTC

Version: 12.2.0.1

Viewed 10K+ times! This question is

You Asked

My System tablespace has grown to approx 15GB. Is that normal??

The top 3 space taking segments are as follows-

I_HH_OBJ#_COL# 1.375
I_HH_OBJ#_INTCOL# 1.375
I_COL1 2.00097656



SQL
sys@oltp28.emdb49> select count(1) from dba_tab_columns;

COUNT(1)
----------
1454820

Elapsed: 00:00:27.61


Is there a defined method to shrink the SYSTEM tablespace??

Would a purge reyclebin help here???

and Chris said...

I wouldn't be too worried about it - unless you're running out of space in your underlying storage.

Assuming your application tables are in a different tablespace, key culprits are auditing and histograms. The I_HH* objects relate to histograms. So you'll need to review your histograms to do anything about these.

Read the following to find out about moving auditing:

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9538627900346341117

See also:

https://asktom.oracle.com/pls/apex/asktom.search?tag=system-tablespace-size
https://mwidlake.wordpress.com/2009/08/03/why-is-my-system-tablespace-so-big/

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database