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
How to end the current transaction in oracle?
What is a table index in oracle?
How to omit columns with default values in insert statement in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Explain compound trigger in oracle?
What is a partition in oracle?
What is a sub query and what are the different types of subqueries?
Explain a data segment?
What are the differences between interval year to month and interval day to second?
Where is the export dump file located?
How to invoke the original export import utilities?
How to load excel data sheet to oracle database
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Explain the use of inctype option in exp command.
Explain the use of tables option in exp command.