1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / daid kumar

We find the Information from V$SYSSTAT
And for Increasing The Hit Ratio we hav eto incraese the
Size Of SGA. by Alter System Command and also In init.ora
file

Is This Answer Correct ?    5 Yes 4 No

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

Answer / abul kasam topon

we can set db_catch_size using alter system command with
scope spfile sid='x';

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More DB Administration Interview Questions

How would you force a log switch?

4 Answers  

Give two examples of referential integrity constraints.

2 Answers  

wat is global index and local indes

1 Answers   Oracle,

how can you implement fine-grained auditing?

0 Answers   Oracle,

Explain about your sql server dba experience? : sql server DBA

0 Answers  




Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

How do you add a data file to a tablespace?

3 Answers  

What purpose does the model database server? : sql server DBA

0 Answers  

Which autogrowth database setting is good? : sql server DBA

0 Answers  

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

For more DB Administration Interview Questions Click Here
Categories