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
- 7036 Views
- IBM, I also Faced
- E-Mail Answers
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 materialized view in Oracle?
What is tns entry?
What happens to indexes if you drop a table?
Name the various constraints used in oracle?
What are group functions in oracle?
How do I connect to oracle database?
What are the differences between blob and clob in oracle?
Point out the difference between user tables and data dictionary?
How to delete an existing row from a table in oracle?
What is proxy method?
How to define a record variable to store a table row?
What is user managed backup in Oracle?
Can we write insert statement in function in oracle?
How to pass a cursor variable to a procedure?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
