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 is difference between sql and mysql?

0 Answers  

---

Difference between table function and pipelined function?

0 Answers  

---

Difference between global and parameter variables?

0 Answers   TCS,

---

What are triggers in sql?

0 Answers  

---

what is global variable in pl/sql

1 Answers  

---

how to include numeric values in sql statements? : Sql dba

0 Answers  

---

What is the need of merge statement?

0 Answers  

---

what is autonomouse transaction?

3 Answers   Oracle,

---

Is a view faster than a stored procedure?

0 Answers  

---

What is procedure explain with example?

0 Answers  

---

How to get list of all tables from a database?

0 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---