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

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  


How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  


What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  


What view would you use to determine free space in a tablespace?

3 Answers  


What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,


deleted of control file how will u recover control file?

4 Answers   CTS,


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  


In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  


What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,


Categories