How would you go about increasing the buffer cache hit ratio?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between clustered and non-clustered index? : sql server DBA
Explain materialized views and how they are used.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is replication? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
internal architecture
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Explain about your sql server dba experience? : sql server DBA
what is the use of ocr?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is fill factor? : sql server DBA
how can you get actual data change values from previous transactions in oracle?