What is the general guideline for sizing db_bloc

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the general guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

Level: High
Expected answer: Oracle almost always reads in 64k chunks. The two should have a product equal to 64 or a multiple of 64.

(Continued on next question...)

Other Job Interview Questions

• What is relation between the window and canvas views?
• What is a Database instance?
• What is the difference between OLE Server & OLE Container?
• What?s the command to change the SQL prompt name?
• What is the purpose of the IMPORT option IGNORE? What is it?s default setting?
• What is the maximum no of chars the parameter can store?
• What are built-ins used for Processing rows?
• What is advantage of having disk shadowing/ Mirroring?
• Which of the above methods is the faster method?
• Explain the relationship among Database, Tablespace and Data file.?
• More...