For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hi,
Can any one suggest me what is the exact storage(size) capacity of blob column.
is this fixed or vary depends on block size?
I confused about the formula
BLOB
DB_BLOCK_SIZE
my server db_block_size=8192 KB.
Thanks and regards,
Ibrahim Sayyed.
BLOB In PLSQL oracle document say's 128TB (11.2g)
SQL (4 GB - 1) * database_block_size
database_block_size
PL/SQL Data Types
It does vary depending on the block size, which itself can vary depending on the initialization parameter and the platform upon which Oracle is installed.
SKP wrote: BLOB In SQL/ plsql the oracle document say's 128TB (11.2g) PL/SQL Data Types
SKP wrote:
BLOB In SQL/ plsql the oracle document say's 128TB (11.2g)
In PL/SQL, yes, but in SQL (database columns) it's based on the block size still.
For your block size of 8192K you're maximum BLOB size is around 32Tb...
SQL> select (((4*1024*1024)-1)*8192)/(1024*1024*1024) as Tb from dual; TB----------31.9999924
SQL> select (((4*1024*1024)-1)*8192)/(1024*1024*1024) as Tb from dual;
TB----------31.9999924
Explanation...
4*1024*1024 turns the 4Gb into K (and then we subtract 1 as per the formula)
The result of that is multiplied by the block size (8192) in K
And then we take the result and...
divide by 1024 to turn K into Mb
divide by 1024 again to turn Mb into Gb
divide by 1024 again to turn Gb into Tb