By using DBMS_PROFILER or DBMS_UTILITY.GET

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.

Question Posted / ammar takieddin

2 Answers
7246 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

Please Help Members By Posting Answers For Below Questions

What is SQL Tuning Advisor in Oracle?

1248

What is an oracle database?

1108

What happens in oracle commit?

1079

How to get a list of all background sessions in the database?

1040

How to display employee records who gets more salary than the average salary in the department?

1126

Explain compound trigger in oracle?

1088

How to use subqueries in the from clause in oracle?

1165

Is the After report trigger fired if the report execution fails ?

2952

How many categories of data types in oracle?

1074

How can I create database in oracle?

1066

What is the meaning of recursive hints in oracle?

1098

What is the string concatenation operator in oracle?

1230

What is user managed backup in Oracle?

1204

What are the types of partitions in oracle?

1078

How to set up autotrace for a user account?

1112