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?
- 0 Answers
- 914 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of the grep command?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
What are the goals of dba?
What is ora-1555 snapshot too old error? Explain in detail?
Does dba need to know programming?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
How do you prevent output from coming to the screen?
What is the difference between truncate and delete? How would a full table scan behave after?
What parameters control copy latches?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
What is end user in database?
Oracle General 
