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

Question Posted / guest

2 Answers
6563 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 will u see whether the dabase is in archive log mode or not?

2 Answers CSC,

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 commands used in dcl? : sql server DBA

0 Answers

how can you implement fine-grained auditing?

0 Answers Oracle,

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

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,

Give the reasoning behind using an index.

2 Answers

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers Tech Mahindra,

What is the difference between Datapump & export/import?

2 Answers

Explain how you would restore a database using RMAN to Point in Time?

1 Answers

What is dcl? : sql server DBA

0 Answers

What is a correlated sub-query? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here