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 are the advantages of sql? Explain

0 Answers  

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---

how to include character strings in sql statements? : Sql dba

0 Answers  

---

How do you concatenate in sql?

0 Answers  

---

What is rule base and cost base optimizer?

2 Answers   Thermotech,

---

What is having clause in sql?

0 Answers  

---

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

---

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

---

What is offset in sql query?

0 Answers  

---

Where is sql database stored?

0 Answers  

---

What are the ways on commenting in a pl/sql code?

0 Answers  

---