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
- 7119 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
Explain the use of file option in exp command.
What is the difference between substr and instr?
How can we create the complete backup of data in the oracle.
What is oracle rowcount?
How to use fetch statement in a loop?
How to create a new table in your schema?
How to work with data objects interactively?
Is oracle an operator?
How to rename an index?
What is the usage of control file in oracle?
How to rename a column in an existing table?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What to do if dba lost the system password?
Write a syntax for update query in oracle?
What are the different pseudo commands? Explain in general?
