What is the cache hit ratio, what impact does it have on
performance of an Oracle database and what is involved in
tuning it?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  


How would you go about increasing the buffer cache hit ratio?

2 Answers  


wat is global index and local indes

1 Answers   Oracle,


how can you enable flashback feature?

0 Answers   Oracle,


How to determine the service pack currently installed on SQL Server?

1 Answers  






How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  


How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  


what is asm?

0 Answers   Oracle,


You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  


Categories