What are the steps you take to tune(performance tuning) the code in plsql?

Question Posted / praveengnr

4 Answers
18279 Views
Cap Gemini, Infosys, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the steps you take to tune(performance tuning) the code in plsql?..

Answer / dinesh kumar

Step 1: Use 3rd Normal form in Database design and create
Indexes in the table.

Step 2: Use Hints in the Query.

Step 3: Use Explain Plan and check for the cost

Step 4: Rewrite the Query to tune as per the Explain plan.

Step 5: Avoid Function based Indexes.

Is This Answer Correct ?

7 Yes

1 No

What are the steps you take to tune(performance tuning) the code in plsql?..

Answer / mathivanan

1.Create indexes
2.keep up to date statistics on tablese
3.Analyse execution plans using trace utilities
4.Make use of Bulk collect,For all,returning bulk collect into.
5.Use hints when necessary
6.Minimize datatype conversions
7.use PLS_INTEGER or BINARY_INTEGER for integer Arithmetic,use BINARY_FLOAT and BINARY_DOUBLE for floating-point arithmetic
8.pin frequently used packages in shared pool memory

Is This Answer Correct ?

2 Yes

0 No

What are the steps you take to tune(performance tuning) the code in plsql?..

Answer / varadarajsha

Using DBMS_PROFILER Package and API

Is This Answer Correct ?

0 Yes

1 No

What are the steps you take to tune(performance tuning) the code in plsql?..

Answer / sandeep

variable_first:=dbms_utility.get_time
variable_last:=dbms_utility.get_time;
dbms_output.put_line('elapsed time':var_first-var_last);

Is This Answer Correct ?

2 Yes

16 No

Post New Answer