Performance - varchar2 columns resize to max

 Hello Team,

I manage a database which contains Electronic programming Guide data for TV.  We ingest this type of data on nightly basis. There have been few time when our vendor does not follow the spec and gives us out of spec data.

This makes us to manually increase the column size and then re-ingest the data. We have asked our vendor to follow the spec or notify us when data lengths changes. BUT this has not worked yet.

This is when we internally decided to increase all the column size for varchar2 to max value for vendor specific data and run a load test against it.