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 pl sql data types?

0 Answers  

---

Can variables be used in sql statements?

0 Answers  

---

What is union?

0 Answers  

---

How to call a javascript function from pl sql?

0 Answers  

---

What is string join?

0 Answers  

---

How do I audit the sql sent to the server?

0 Answers  

---

What is a mutating table and a constraining table?

0 Answers  

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,

---

What are the built in functions of sql?

0 Answers  

---

What is spool?

0 Answers  

---

What is primary key and unique key?

0 Answers  

---