Answer Posted / 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);

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

2614

---

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?

2476

---

what are the types of connection load-balancing?

983

---

Which autogrowth database setting is good? : sql server DBA

1131

---

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

1062

---

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

7870

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1185

---

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

1096

---

how does an oracle clusterware manage crs resources?

1068

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1243

---

What are the different ways you can create databases in sql server? : sql server DBA

1119

---

What is dcl? : sql server DBA

1239

---

What the different types of replication and why are they used? : sql server DBA

1160

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2087

---

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

1167

---