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 is the difference between truncate and delete? How would a full table scan behave after?
What is dba and functionalities of dba?
What is the purpose of the import option ignore? What is its default setting?
What are the five functions of a database?
What do you understand by a control file?
What are the daily activities of oracle dba?
While taking hot backup (begin end backup) what will happens back end?
When should an artificial (or derived) primary key be used?
When should the default values for oracle initialization parameters be used as is?
What does the no logging option do? Why would we be careful of using it?
How can you determine the number of sqlnet users logged in to the unix system?
How can you find out how many users are currently logged into the database?