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

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

2 Answers   TCS,

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

How many packages we have in db

1 Answers   Tesco,




how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

deleted of control file how will u recover control file?

4 Answers   CTS,

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

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

0 Answers  

What is replication? : sql server DBA

0 Answers  

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

For more DB Administration Interview Questions Click Here
Categories