Answer / Kumar Gaurav Sagar

Connection load balancing in Oracle Database helps distribute workload across multiple servers. The two primary types are server response time (SRT) and round robin. SRT uses the response time of each server to balance connections, while round robin distributes connections evenly among available servers.

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1 Answers  

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1 Answers  

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

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

1 Answers  

---

How do you add a data file to a tablespace?

3 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

Where would you look for errors from the database engine?

1 Answers   IBM,

---

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1 Answers  

---