Answer / b.r.reddy

We can manually set the statistical values.
We can gather statistics in parallel mode.

what is a user-defined lock?

0 Answers   Oracle,

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

How would you force a log switch?

4 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

What command would you use to create a backup control file?

2 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---