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')

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

what is ora 600?

1 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

What the different types of replication and why are they used? : sql server DBA

0 Answers  

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

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

0 Answers  

---

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

0 Answers  

---

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

0 Answers  

---