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 does an oracle clusterware manage crs resources?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the operating modes in which database mirroring runs? : sql server DBA
how can you process messages in order asynchronously?
Why would you use sql agent? : sql server DBA
what do you understand by flashback feature of oracle?
Why would you call update statistics? : sql server DBA
what are the benefits of flashback feature?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the commands used in dcl? : sql server DBA
how can you create a user-defined lock?