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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---

what are the differences of where and if in SAS?

0 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

Hot backup procedure?

2 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,

---

Why would you call update statistics? : sql server DBA

0 Answers  

---

What command would you use to create a backup control file?

2 Answers  

---

What is replication? : sql server DBA

0 Answers  

---