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

Question Posted / guest

2 Answers
7143 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

what is the difference between catalog & nocatalog?

3 Answers CSC,

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers

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

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,

why we use cursors

1 Answers

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

0 Answers

how can you initialize log miner?

0 Answers Oracle,

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

how will you see when the database was started using sql prompt?

2 Answers IBM,

What is the importance of a recovery model? : sql server DBA

0 Answers

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers

For more DB Administration Interview Questions Click Here