How Would You Go About Increasing The Buffer Cache Hit Ratio?

1.	How Would You Go About Increasing The Buffer Cache Hit Ratio?
Answer» Use the BUFFER cache ADVISORY over a given WORKLOAD and then query the v$db_cache_advice table. If a CHANGE was necessary then I would use the alter system set db_cache_size command. Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.

Answer»

Use the BUFFER cache ADVISORY over a given WORKLOAD and then query the v$db_cache_advice table. If a CHANGE was necessary then I would use the alter system set db_cache_size command.

Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.

Discussion

No Comment Found

Related InterviewSolutions

Name Two Files Used For Network Connection To A Database.
How Can You Gather Statistics On A Table?
You Have Just Compiled A Pl/sql Package But Got Errors, How Would You View The Errors?
Explain What Partitioning Is And What Its Benefit Is.
How Can You Rebuild An Index?
How Would You Determine Who Has Added A Row To A Table?
What View Would You Use To Determine Free Space In A Tablespace?
What View Would You Use To Look At The Size Of A Data File?
How Do You Resize A Data File?
How Do You Add A Data File To A Tablespace?

How Would You Go About Increasing The Buffer Cache Hit Ratio?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment