Answer / santosh

you can use dbms_stats package

Answer / guest

We can gather statistics on a table through>>

analyze table TABLE_NAME compute statistics , or

analyze table TABLE_NAME estimate statistics


Regards
Abhinav

Answer / balu

exec dbms_stats.gather_table_stats('ownername','tablename')

How can you gather statistics on a table?

3 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

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

5 Answers   CSC, Logica CMG,

---

Explain CREATE DATABASE syntax?

2 Answers  

---

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

0 Answers  

---

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

what is ora 600?

1 Answers  

---

how can you record information about current session?

0 Answers   Oracle,

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---