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

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,


what is ora 600?

1 Answers  


by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,


what r the types of backup?

5 Answers   CSC,


what is grd?

0 Answers   Oracle,






I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  


Which environment variables are absolutely critical in order to run the OUI?

2 Answers  


How can we know the exact updation date of a particular database?

2 Answers   Satyam,


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  


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

0 Answers  


Oracle 11g new features?

2 Answers  


How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  


Categories