Choosing the right blocksize for Oracle Database tablespaces with lobs
2
votes
1
answer
979
views
We are currently switching from an older character set to Unicode using impdp/expdp on Oracle Database 19c. We had to changed several data types. We changed tables with LOBs from basicfile to securefile and found that the tablespace holding this lobs only uses an 8K blocksize. The table containes several TBs with pdfs around 2-3mb. Does it makes sense to increase the Blocksize of the tablespace holding the LOBs from 8k to 32k?
Asked by r0tt
(1078 rep)
Mar 2, 2021, 04:38 PM
Last activity: May 16, 2024, 04:29 PM
Last activity: May 16, 2024, 04:29 PM