Answer / suman

we have 8 packages in our database that is
1.procedures
2.triggers
3.tables
4.indexes
5.synonyms
6.views

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

What is the dataguard background process??

1 Answers   iGate,

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

What is the default fill factor value? : sql server DBA

0 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

what is the differnce between process and thread ?

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  

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---