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 / 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 |
Post New Answer View All Answers
How are extents allocated to a segment?
How to display employee records who gets more salary than the average salary in the department?
What is the difference between view and materialized view in Oracle?
How do I escape a reserved word in oracle?
How to use "for" statements in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
How to use subqueries with the in operator using oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is the oracle implicit cursor?
Explain the types of exception?
How to use values from other tables in update statements using oracle?
How to best split csv strings in oracle 9i?
Difference between hot backup vs. Cold backup?
How to create a table index in oracle?
How do I connect to oracle database?