Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
No Answer is Posted For this Question
Be the First to Post Answer
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
How many control files should you have?
What happens if a tablespace clause is left off of a primary key constraint clause?
What are roles in oracle?
Tell me about standby database? What are some of the configurations of it?
Which date function is used to find the difference between two dates?
How do you prevent output from coming to the screen?
What is an artificial (derived) primary key?
Discuss row chaining, how does it happen? How do you correct it?
How can you determine if an oracle instance is up from the operating system level?
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 I become an administrator?