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
- 7035 Views
- IBM, I also Faced
- E-Mail Answers
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
Why does Oracle not permit the use of PCTUSED with indexes?
What is recovery manager(rman) backup in Oracle?
What are the differences between number and binary_float in oracle?
How to estimate disk space needed for an export job?
What is private procedure oracle?
what is the difference between restoring and recovering?
What are the numeric comparison operations?
What is blob datatype?
What is system global area (sga) in oracle?
Are truncate and delete commands same? If so why?
How many types of tables supported by oracle?
What happens if variable names collide with table/column names?
Explain what are the characteristics of data files?
How index is implemented in oracle database?
6. Display the client name and order date for all orders using the traditional method.
