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

Question Posted / guest

2 Answers
7242 Views
I also Faced
E-Mail Answers

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 does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers

How would you extract DDL of a table without using a GUI tool?

0 Answers

Hot backup procedure?

2 Answers

What are the commands used in dcl? : sql server DBA

0 Answers

What column differentiates the V$ views to the GV$ views and how?

3 Answers

how can a session indicate its interest in receiving alerts?

0 Answers Oracle,

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers Infozech, Wipro,

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

2 Answers

Name three advisory statistics you can collect.

1 Answers

how can you record information about current session?

0 Answers Oracle,

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

what is the use of ocr?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here