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.
Answer Posted / ammar takieddin
By using DBMS_PROFILER or DBMS_UTILITY.GET_TIME
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the max number of columns in an oracle table?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
defination of bitmap index
Name the three major set of files on disk that compose a database in Oracle?
Who developed oracle & when?
How to use subqueries in the from clause in oracle?
What is a synonym? What are its various types?
How to connect to the server with user account: sys?
What is a trigger and what are its types in oracle?
What are the various constraints used in oracle?
How to export data to a csv file?
Can multiple columns be used in group by in oracle?
What are the logical operations?
List the parts of a database trigger.
Explain the function of optimizer in oracle?