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
- 6093 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 oracle instant client?
List the parts of a database trigger.
List out the types of joins.
What is an oracle wallet?
What are the uses of Rollback Segment ?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
difference between procedures and function?
Differnce between view and index
What is execute immediate in oracle?
how can we store any pdf file in oracle
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is a table in oracle?
Oracle General 
