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 do you understand by fine-grained auditing?

0 Answers   Oracle,

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

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

0 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

What is the difference between Datapump & export/import?

2 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---