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 authentication modes does sql server support? : sql server DBA

0 Answers  

---

what is meant by gateway

1 Answers   IBM,

---

What are the recovery models for a database? : sql server DBA

0 Answers  

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

Describe what redo logs are.

1 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

What purpose does the model database server? : sql server DBA

0 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---