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

Question Posted / guest

2 Answers
7097 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 ora 600?

1 Answers

Why would you call update statistics? : sql server DBA

0 Answers

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers

Where in the Oracle directory tree structure are audit traces placed?

1 Answers

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

0 Answers

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers

what is the use of home directory???

1 Answers HP,

How does Oracle guarantee data integrity of data changes?

1 Answers SoftSol,

Hot backup procedure?

2 Answers

deleted of control file how will u recover control file?

4 Answers CTS,

For more DB Administration Interview Questions Click Here