Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps you take to tune(performance tuning) the code in plsql?
- 4 Answers
- 18122 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
What is meant by cursor in sql?
How many sql commands are there?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
which types of join is used in sql widely? : Sql dba
What is meant by <> in sql?
What is function and procedure?
What is sql engine in oracle?
Explain what is a view?
What is sql*loader and what is it used for? : aql loader
What are the ways on commenting in a pl/sql code?
What is information schema in sql?
Explain the types of joins in sql?
What is primary key secondary key alternate key candidate key?
Is pl sql a scripting language?
