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
- 6574 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 |
Can a primary key contain more than one columns?
what is the scenario where you take the database to NoArchivelog mode?
How different is ms access and oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to empty your oracle recycle bin?
What happens to the current transaction if a ddl statement is executed?
How do I recompile a procedure in oracle?
what is the syntax of CREATE command?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is the maximum number of triggers that can be applied to a single table?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is oracle datasource?
Oracle General 
