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
What skills do you need to be a database administrator?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
What exactly does a dba do?
Are database administrators in demand?
How do I become a data manager?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
Explain the various modes of normalization?
How would you find total size of database in os level?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
Give one method for transferring a table from one schema to another?
Discuss row chaining, how does it happen?