How would you go about increasing the buffer cache hit ratio?
Answer Posted / 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 View All Answers
how can you create a user-defined lock?
Why does Oracle not permit the use of PCTUSED with indexes?
how does an oracle clusterware manage crs resources?
what is logical system in sap basis
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is a crs resource?
What are statistics, under what circumstances they go out of date, how do you update them?
how can you initialize log miner?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
what is the use of recording information about current session?
which background process invoke at the time of upgradation tell me???
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.