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

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

1 Answers  

---

What is transparent data encryption? : sql server DBA

1 Answers  

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

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

1 Answers  

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

how can you connect from 10g user to 11g user??

1 Answers   HP,

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

. 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?

1 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1 Answers   Patni,

---