What are the steps you take to tune(performance tuning) the code in plsql?
- 4 Answers
- 16964 Views
- Cap Gemini, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / varadarajsha
Using DBMS_PROFILER Package and API
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a system versioned table?
What is trigger and how to use it in sql?
Advantages and disadvantages of stored procedure?
Explain aggregate functions are available there in sql?
What are the possible values for the boolean data field?
how can we repair a mysql table? : Sql dba
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Is left join same as join?
What is a record in a database?
What is function and procedure?
What is sqlite used for?
What is sql prepared statement?
What is dml statement?
what are wild cards used in database for pattern matching ? : Sql dba
How do I run a script in sql developer?
