Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7243 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 |
How to Remove the 3rd highest salary person record from table?
What is a proxy class?
What are operators in oracle?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
if you ctreate table identity
How do I escape a reserved word in oracle?
How to write a query with an inner join in oracle?
How do I uninstall oracle client from windows?
What is self-referential integrity constraint ?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
How to update a table row with a record?
What is a snapshot in oracle database?
Oracle General 
