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
What do you understand by the term 'system change number (scn)'?
How do you set up your tablespace on installation level: low?
Which date function is used to find the difference between two dates?
What are some indications that you need to increase the shared_pool_size parameter?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What are types of data model?
How do you generate file output from sql?
Who is a database user?
What operator tests column for the absence of data?
Discuss row chaining, how does it happen? How do you correct it?
What are the five functions of a database?
Can you remove an open file under unix?