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);

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

933

---

what is logical system in sap basis

1576

---

what are the types of connection load-balancing?

938

---

What the different topologies in which replication can be configured? : sql server DBA

1180

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

949

---

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

1077

---

what do you understand by fine-grained auditing?

1014

---

How can you control the amount of free space in your index pages? : sql server DBA

1233

---

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

1110

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1984

---

how can you schedule a job in database?

1043

---

What types of replication are supported in sql server? : sql server DBA

1224

---

what is asm?

995

---

Explain about your sql server dba experience? : sql server DBA

1023

---

What are the operating modes in which database mirroring runs? : sql server DBA

1106

---