Answer / dinesh kumar

Step 1: Use 3rd Normal form in Database design and create
Indexes in the table.

Step 2: Use Hints in the Query.

Step 3: Use Explain Plan and check for the cost

Step 4: Rewrite the Query to tune as per the Explain plan.

Step 5: Avoid Function based Indexes.

Answer / 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

Answer / varadarajsha

Using DBMS_PROFILER Package and API

Answer / sandeep

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

What is the full form of sql?

1 Answers  

---

Can we rollback after truncate?

0 Answers  

---

Write a unique difference between a function and a stored procedure.

0 Answers  

---

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

---

How we can update the view?

0 Answers  

---

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

---

Explain the working of foreign key?

0 Answers  

---

what is global variable in package

3 Answers   Polaris,

---

When should I use nosql database?

0 Answers  

---

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

---

what are the difference between clustered and a non-clustered index? : Sql dba

0 Answers  

---

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

---