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

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

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

0 Answers  

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

---

what is a user-defined lock?

0 Answers   Oracle,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

Can we take incremental backups in datapump?

1 Answers  

---

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

3 Answers   TCS,

---

what is the use of ocr?

0 Answers   Oracle,

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

What would you do with an "in-doubt" distributed transaction?

0 Answers  

---