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 happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers  

---

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

What is primary key and foreign key with example?

0 Answers  

---

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

---

Which are the most commonly used sql joins?

1 Answers  

---

what is difference between pass by value and eference by value in oracle plsql

1 Answers  

---

What is substitution variable?

0 Answers  

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

What are advantages of Stored Procedures?

3 Answers   Satyam,

---

How to disable a trigger name update_salary?

0 Answers  

---

How can you view the errors encountered in a trigger?

0 Answers  

---