Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

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

2 Answers  


In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  


How do you add a data file to a tablespace?

3 Answers  


when does an alert gets signaled?

0 Answers   Oracle,


What is a system database and what is a user database? : sql server DBA

0 Answers  


how can you connect from 10g user to 11g user??

0 Answers   HP,


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?

1 Answers  


What is replication? : sql server DBA

0 Answers  


How would you force a log switch?

4 Answers  


What is the difference between Datapump & export/import?

2 Answers  


What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  


Categories