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

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

How do you resize a data file?

2 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

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

0 Answers  

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

How would you force a log switch?

4 Answers  

---

what is rebuild index??

2 Answers   IBM, Sapient,

---

How do you add a data file to a tablespace?

3 Answers  

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---