How would you go about increasing the buffer cache hit ratio?
Answers were Sorted based on User's Feedback
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 |
we can set db_catch_size using alter system command with
scope spfile sid='x';
| Is This Answer Correct ? | 0 Yes | 2 No |
How would you go about increasing the buffer cache hit ratio?
In oracle 10g export, import if we declare rows=y/n what would be the output?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How do you add a data file to a tablespace?
when does an alert gets signaled?
What is a system database and what is a user database? : sql server DBA
how can you connect from 10g user to 11g user??
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?
What is replication? : sql server DBA
How would you force a log switch?
What is the difference between Datapump & export/import?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)