What are the steps you take to tune(performance tuning) the code in plsql?
- 4 Answers
- 16959 Views
- Cap Gemini, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How is a process of pl/sql compiled?
Can we use having without group by in sql?
How to add a column ‘salary’ to a table employee_details?
What is varchar example?
What are the key differences between SQL and PL SQL?
explain commit and rollback in mysql : sql dba
What is difference between sql and oracle?
What are the two different parts of the pl/sql packages?
give the syntax of grant and revoke commands? : Sql dba
What are the commands used in sql?
What is pragma in sql?
What is the purpose of using pl/sql?
What is a composite primary key?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is multiple partition?
