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


Please Help Members By Posting Answers For Below Questions

How to end the current transaction in oracle?

776


What is a table index in oracle?

857


How to omit columns with default values in insert statement in oracle?

825


1) Does oracle have any table which contain all the exceptions and it's code internally?

1516


Explain compound trigger in oracle?

785


What is a partition in oracle?

793


What is a sub query and what are the different types of subqueries?

886


Explain a data segment?

850


What are the differences between interval year to month and interval day to second?

778


Where is the export dump file located?

807


How to invoke the original export import utilities?

713


How to load excel data sheet to oracle database

776


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?

1997


Explain the use of inctype option in exp command.

810


Explain the use of tables option in exp command.

841