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

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: Mon Dec 05 21:00:05 CST 2016

Total time taken to generate the page: 0.15746 seconds