variable_first:=dbms_utility.get_time variable_last:=dbms_utility.get

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

Question Posted / sandeep

Answer Posted / sandeep

variable_first:=dbms_utility.get_time
variable_last:=dbms_utility.get_time;
dbms_output.put_line('elapsed time':var_first-var_last);

Is This Answer Correct ?

2 Yes

16 No

Please Help Members By Posting Answers For Below Questions

What is exit statement?

1009

what is rdbms? : Sql dba

1012

What is a sql*loader control file?

1256

how can we repair a mysql table? : Sql dba

973

How do you optimize a stored procedure in sql?

948

Is progress software supports to ( pl/sql )?

1033

how to fetch common records from two tables? : Sql dba

1172

What is cursor in pl sql?

1114

What are the basic techniques of indexing?

1057

What is difference between stored procedures and application procedures?

1009

What is dcl in sql?

956

What is difference between inner join and self join?

1079

how to install mysql? : Sql dba

1102

Which data dictionary views have the information on the triggers that are available in the database?

1232

What is the difference between the implicit and explicit cursors?

1044