Answer Posted / guest

We can gather statistics on a table through>>

analyze table TABLE_NAME compute statistics , or

analyze table TABLE_NAME estimate statistics


Regards
Abhinav

what is ora 24313?what is the procedure to exclude that error?

2608

---

What purpose does the model database server? : sql server DBA

1258

---

what is logical system in sap basis

1695

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1121

---

what is a crs resource?

1232

---

How would you extract DDL of a table without using a GUI tool?

2530

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2012

---

how can you schedule a job in database?

1192

---

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

4476

---

how to restore files with rman?

2355

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2145

---

Query processing is slow(eg select query)how will u solve that

8031

---

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

1153

---

What are the different sql server versions you have worked on? : sql server DBA

1066

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1159

---