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
How do I become a database administrator?
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?
How do you generate file output from sql?
What are the five functions of a database?
What are the main functions of dba?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
Discuss row chaining, how does it happen? How can you reduce it?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
How do I become a dba?
What do you mean by oracle database?
When should you increase copy latches?
What are roles in oracle?