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 dbcc? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is the use of recording information about current session?
Which autogrowth database setting is good? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
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
Where would you look for errors from the database engine?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?