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
- 6066 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 a Tablespace?
Can you have more than one content canvas view attached with a window ?
Which is better Oracle or MS SQL? Why?
pls explain connect by prior with example and its real time use
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Is the After report trigger fired if the report execution fails ?
What is the scope of a local variable?
Will you be able to store pictures in the database?
Explain about the analyze command in oracle?
What are the restrictions on external table columns?
How to sort output in descending order in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Oracle General 
