Answer / bupesh

There are various ways to do this :
1) We can run individual objects (Procedures and Functions)
to get the timestamps and then work on the one with slow
performance.
2) We can also get the trace of the entire Package and
identify the slow objects.
3) We can use DBMS_APPLICATION_INFO to gather the
statistics at runtime using V$SESSION

Answer / ammar takieddin

By using DBMS_PROFILER or DBMS_UTILITY.GET_TIME

What is rowid and rownum in oracle?

0 Answers  

---

How will you identify oracle database software release?

0 Answers  

---

What is a view and how is it different from a table?

0 Answers  

---

How to call a trigger inside a stored procedure?Give an example.

2 Answers  

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---

One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.

6 Answers   Polaris,

---

What is RULE-based approach to optimization ?

1 Answers  

---

Can a formula column be obtained through a select statement ?

0 Answers   Oracle,

---

structural difference between bitmap and btree index ?

1 Answers   Infosys,

---

How to write a left outer join with the where clause in oracle?

0 Answers  

---

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

---