If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
No Answer is Posted For this Question
Be the First to Post Answer
What skills should a dba have?
What is end user in database?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What is main function of database administrator?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
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 is the easiest method to create a file on unix?
What skills do you need to be an administrator?
How to uncatalog backup?
What are the different types of database users?