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
- 6056 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ammar takieddin
By using DBMS_PROFILER or DBMS_UTILITY.GET_TIME
| Is This Answer Correct ? | 5 Yes | 0 No |
What is the difference between sharding and partitioning?
What is tns name?
How to use subqueries in the from clause in oracle?
What are the execution control statements?
What is the meaning of recursive hints in oracle?
candidate key is subset of super key but not vice-verse explain
Explain coalesce function?
How to view all columns in an existing table?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
Describe varray?
6. Display the client name and order date for all orders using the traditional method.
List the various oracle database objects?
Oracle General 
