We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

how do get database name at sql prompt?

3 Answers  

---

What are the roles of dba?

0 Answers  

---

What is OCI. What are its uses?

1 Answers  

---

How to use regular expression in pattern match conditions in oracle?

0 Answers  

---

---

How to connect ms access to oracle servers?

0 Answers  

---

master table and child table performances and comparisons in Oracle ?

0 Answers  

---

What is a relational database management system?

0 Answers  

---

How to retrieve 5th highest sal from emp table?

8 Answers  

---

What are virtual columns?

2 Answers   TCS,

---

What are the type of Synonyms?

1 Answers  

---

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 Answers  

---