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

Report message to a moderator

Previous Topic: Performance issue
Next Topic: gather stats estimated
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 16:32:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.