Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

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

0 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

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

0 Answers  

---

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

1 Answers   CTS,

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

What does coalescing a tablespace do?

1 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---