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
How to add a new column to an existing table with a default value?
Difference between oracle's plus (+) notation and ansi join notation?
What do you mean by merge in oracle and how can we merge two tables?
How to change program global area (pga) in oracle?
How to delete a column in an existing table?
Can a formula column referred to columns in higher group ?
What do database buffers contain?
Explain oracle 12c new features for developers?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is oracle data type?
How to pass a parameter to a cursor in oracle?
How to execute a stored procedure in oracle?
How to Truncate Table in Oracle
How to return top 5 rows in oracle?
Is insert autocommit in oracle?