Answer / shiva

After we have verified that STATSPACK is installed and working, we can schedule automatic data collection. By using the statsauto.sql script we can automatically schedule an hourly data collection for STATSPACK. The statsauto.sql script contains the following directive:

SQL> execute dbms_job.submit(:jobno, 'statspack.snap;',
trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno);

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

0 Answers   Oracle,

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

---

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

0 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

how can you enable flashback feature?

0 Answers   Oracle,

---

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

0 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

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

0 Answers  

---

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

0 Answers  

---