| Size of Blob Column is high [message #621544] |
Thu, 14 August 2014 02:12  |
manyal
Messages: 84
Registered: March 2005
|
Member |
|
|
Friends,
I upload photo using client_get_file_name()in form and database column type is blob.
average image size is 25 k but when we see blob size using dbms_lob.getlength() it is showing value 1061617 for all records , which is very high.
what may be the reason and how to overcome this problem as this value is very high as far as space is concerned.
row chunk value of blob column is ROW CHUNK 8192.
Regards,
Manyal
|
|
|
|
|
|
|
|
|
|
| Re: Size of Blob Column is high [message #621580 is a reply to message #621575] |
Thu, 14 August 2014 10:48  |
manyal
Messages: 84
Registered: March 2005
|
Member |
|
|
actually altering the blob type as secured type would be the last option as the system is in production, is there any other way.
and i want to know the reason of such a big and constant length (1061617) for this column for all rows, inspite of small size(25k) of images being stored into this.
[Updated on: Thu, 14 August 2014 10:49] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
