Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle DBA (Database Administration) Interview Questions

How do I become a database administrator?

0 Answers  


You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

0 Answers  


How do you generate file output from sql?

0 Answers  


What are the five functions of a database?

0 Answers  


What are the main functions of dba?

0 Answers  






What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

0 Answers  


Discuss row chaining, how does it happen? How can you reduce it?

0 Answers  


Tell me about standby database? What are some of the configurations of it? What should we watch out for?

0 Answers  


How do I become a dba?

0 Answers  


What do you mean by oracle database?

0 Answers  


When should you increase copy latches?

0 Answers  


What are roles in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)