An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

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

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

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  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

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

0 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---

what is the use of ocr?

0 Answers   Oracle,

---