1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is single byte over head in oracle..?

Question Posted / neelima.gg


what is single byte over head in oracle..?..

Answer / 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

More SQL PLSQL Interview Questions

What are the different types of joins and explain them briefly.

3 Answers  

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

What is an Exception ? What are types of Exception ?

2 Answers  

Is primary key always clustered index?

0 Answers  

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 Answers  

how to create a database in oracle?please gve anser with example

1 Answers  

Why do we use %rowtype & %type in plsql?

1 Answers  

How to execute a stored procedure?

1 Answers  

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

How many joins can you have in sql?

1 Answers  

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

What is java sql connection?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories