Windchill's Blobs Tablespace is filling up quickly.

[Aden]

I use the Windchill 12.0.2.5 and Oracle Database. 

Our Database's Blobs tablespace is filling up quickly.

Almost it is filling up 1GB per day. Before 2023, Blobs table isn't filled up like this. 

How can I manage or reduce the amount of Blobs table space?

[HelesicPetr · Accepted solution]

Hi @Aden 

Someone forget to set the vault rule configuration on new context or you had set preference to force all content to vault

check following article: CS68929

if you do not use vault rules use setting wt.fv.useVaultsForAllContent=true 

hope this can help

PetrH

[mmeadows-3]

Expanding on Petr's solution, if this is a legacy system and the BLOBS growth is just over the last few months, then most likely your master file vault and root folder have switched to read only.

Site > Utilities > File Server Administration > Vault Configuration

Double click on the vault and associated root folder to confirm they aren't read-only.

Assuming you system is forcing content to vault via CS68929, manually revault to clean recover your BLOBS space.

• Oracle: CS37197
• SQL Server: CS81914

After releasing the space on SQL Server, you need to defragment (reorganize/rebuild) the database indexes.  There will be performance issues if you don't.  Ola Hallengren's index maintenance script works great. CS193197

[HelesicPetr]

Hi @mmeadows-3 

Good point. If the useVaultsForAllContent is not set that the reason could be: the vaults are locked. 

PetrH

[Aden]

@mmeadows-3 Thank u for replying my question

I will check up your replying. 

[Aden]

@HelesicPetr  Thank u for replying my question. 

I will take this solution and apply with our engineers.