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 write a query with a left outer join in oracle?
how to handle exceptions in post production
What happens to the current transaction if the session is ended?
What is the use of oracle?
What are temporal data types in oracle?
what are archived logs?
How to loop through data rows in the implicit cursor?
Does facebook use oracle?
How to load excel data sheet to oracle database
Write a trigger example in oracle?
How to use "out" parameter properly?
How to define an anonymous block?
Why do we need integrity constraints in a database?
How to display employee records who gets more salary than the average salary in the department?
How do I find the database name in oracle?