Home » RDBMS Server » Performance Tuning » shink blob column (oracle
shink blob column [message #340103] Mon, 11 August 2008 08:23
Messages: 136
Registered: November 2006
Senior Member

We have a blob column in a table , tied to a lob segment its size has increased from 1 GB to 13 GB in 10 days.
We have checked with the help of substr function that the column contains a lot of free space . Is there a way to remove this free space or to shrink this column.

Kindly suggest
Thanks & Regards
Previous Topic: Performance issue
Next Topic: gather stats estimated
Goto Forum:

Current Time: Thu Jul 27 23:55:16 CDT 2017

Total time taken to generate the page: 0.07076 seconds