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

Answer / abul kasam topon

we can set db_catch_size using alter system command with
scope spfile sid='x';

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

How can you gather statistics on a table?

3 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

How do you add a data file to a tablespace?

3 Answers  

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---