Answer / s.panda

Step1: At first we need to identified the high load SQLs or
top SQLs that are responsible for performance problem or in
another word the sql that consume application workload and
system resources. We can easily identify them by reviewing
past SQL execution history available in the system.

Step 2: Now generate execution plan of those high load sql
statements and verify that the execution plans produced by
the query optimizer for these statements perform reasonably.

Step 3: Implement corrective actions to generate better
execution plans for poorly performing SQL statements. While
taking corrective actions there is many considerations.

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,

---

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

---

What is Difference between StoredProcedure and function?

3 Answers  

---

What is scope of pl sql developer in future?

0 Answers  

---

How to select unique records from a table?

0 Answers  

---

What is sql used for?

0 Answers  

---

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

---

Advantages and disadvantages of stored procedure?

0 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

What is the usage of the distinct keyword?

0 Answers  

---

Is left join same as inner join?

0 Answers  

---

What is plpgsql language?

0 Answers  

---