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

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1944

---

What is replication? : sql server DBA

1102

---

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

1097

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

972

---

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

1051

---

how can a session indicate its interest in receiving alerts?

980

---

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

1010

---

What is fill factor? : sql server DBA

1181

---

what are the types of connection load-balancing?

937

---

Why does Oracle not permit the use of PCTUSED with indexes?

2879

---

What is transparent data encryption? : sql server DBA

1115

---

what is logical system in sap basis

1576

---

what do you understand by flashback feature of oracle?

946

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2580

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3343

---