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.

Answer Posted / ammar takieddin

By using DBMS_PROFILER or DBMS_UTILITY.GET_TIME

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to add a new column to an existing table with a default value?

813


Difference between oracle's plus (+) notation and ansi join notation?

877


What do you mean by merge in oracle and how can we merge two tables?

839


How to change program global area (pga) in oracle?

869


How to delete a column in an existing table?

832


Can a formula column referred to columns in higher group ?

2292


What do database buffers contain?

793


Explain oracle 12c new features for developers?

798


State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

825


What is oracle data type?

766


How to pass a parameter to a cursor in oracle?

876


How to execute a stored procedure in oracle?

854


How to Truncate Table in Oracle

914


How to return top 5 rows in oracle?

817


Is insert autocommit in oracle?

829