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 to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
when does an alert gets signaled?
Explain materialized views and how they are used.
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
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 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 are the different types of database compression introduced in sql server 2008? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How would you extract DDL of a table without using a GUI tool?
What are the different types of indexes available in sql server? : sql server DBA
what is the diffrence between core dba and apps dba?
What is dcl? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?