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

Answer Posted / varadarajsha

Using DBMS_PROFILER Package and API

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

552


What is full join?

525


What makes a good primary key?

519


How can we solve sql error: ora-00904: invalid identifier?

697


What are the advantages of indexing?

517






What is trigger in sql?

576


Define sql delete statement.

560


Is sql a backend?

545


What is the use of pl/sql table?

553


Does sql view stored data?

534


Can a primary key be a foreign key?

573


What is the best partition size for windows 10?

479


Can a table contain multiple primary key’s?

622


Can a procedure in a package be overloaded?

544


What is mdf ldf and ndf?

558