adspace


what is single byte over head in oracle..?

Answer Posted / Sanchit Kumar

In Oracle, the single byte overhead (SBO) refers to the additional memory that is used by Oracle for each database block. It includes the control bytes (CB), header bytes (HB), and trailer bytes (TB). The total single byte overhead can be calculated as: SBO = (CB + HB + TB) / block size.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do we need to rebuild index after truncate?

1149


what is sql server agent? : Sql dba

1186


What is your daily office routine?

2351


how to escape special characters in sql statements? : Sql dba

1122


what are all the common sql function? : Sql dba

1137


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2097


Is primary key always clustered index?

1101


how to start mysql server? : Sql dba

1275


what is bcp? When does it used? : Sql dba

1063


what is dbms? : Sql dba

1067


define sql insert statement ? : Sql dba

1104


What is the best sql course?

1057


what are the advantages of sql ? : Sql dba

1148


how many tables will create when we create table, what are they? : Sql dba

1151


What is the current version of sql?

1100