ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What database block size should I use?

user-image
تم إضافة السؤال من قبل Zaid Rabab'a , Software Development Team Leader , Al-Safa Co. Ltd.
تاريخ النشر: 2013/07/14
Jad Al-Quraan
من قبل Jad Al-Quraan , Head of department : analysis and systems development & Oracle DBA , Tafila Technical University

It depends on the type of data that will be stored in the database

For example, if you want to create a database depends entirely on the storage of binary data (pictures or something like that)

You need to choose the large size for block

Fadi Alkhateeb
من قبل Fadi Alkhateeb , Senior Front End Developer , NexTwo

According to http://knowledgebase.progress.com/articles/Article/18293 you can use8K size.
And below is link for Block size tips from Oracle: http://www.dba-oracle.com/s_oracle_block_size.htm

Ram Kishore Dindakurthi Tulasi
من قبل Ram Kishore Dindakurthi Tulasi , Vice President , CITI Bank

As Fadi Said...
most generic is8k Block size It all depends on the purpose of the database and what kind of data you are going to store...
You can also use multiple block sizes in a database...
let say that you have multiple schemas and application in a single database one application you have all the small tables and data is accessed randomly then you can use smaller block size (it has to be defined in init.ora as well as while creating tablespace) for another application where you have big tables and rows to be accessed then its good to use bigger block size tablespace...
Hope this helps

المزيد من الأسئلة المماثلة