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 where clause and having clause? : Sql dba

539


what are the different type of sql's statements ? : Sql dba

522


How to select all records from the table?

609


What is a function in oracle pl sql?

543


Define sql delete statement.

566






How do we accept inputs from user during runtime?

548


What is data type in database?

546


What is online transaction processing (oltp)?

601


What is the basic form of sql query?

495


Is left join inner or outer by default?

523


How do I create a memory optimized filegroup?

529


What is cte?

574


Why trigger is used in sql?

532


How to display the records between two range in Oracle SQL Plus?

641


Differentiate between pl/sql and sql?

617