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
- 7149 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 |
Is the After report trigger fired if the report execution fails ?
Please explain compound trigger in oracle?
How to find no of saturdays in a month using single sql ?
What is the difference between a hot backup and a cold backup in oracle?
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
Explain how are indexes update?
what r routers?
What is the difference between Sleep and Wait? (Java)
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
What is the data pump export utility?
In Oracle 9i what does "i" Stands for?
What is Row Chaining ?
Oracle General 
