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.

How to create your own reports in sql developer?

0 Answers  

---

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers   Pitney Bowes,

---

How to run pl/sql statements in sql*plus?

0 Answers  

---

What is character functions?

0 Answers  

---

what is 'mysqladmin' in mysql? : Sql dba

0 Answers  

---

Which is better cte or subquery?

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

Does sql require a server?

0 Answers  

---

How to return multiple records from procedure?

2 Answers  

---

How do I kill a query in postgresql?

0 Answers  

---

What are dml commands?

0 Answers  

---

What is Data Concarency and Consistency?

1 Answers  

---