Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
- 1 Answers
- 8777 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is pivot table in sql?
What are the different datatypes available in PL/SQL?
how many sql dml commands are supported by 'mysql'? : Sql dba
What will you get by the cursor attribute sql%notfound?
what are the advantages a stored procedure? : Sql dba
What is the difference between execution of triggers and stored procedures?
what are enums used for in mysql? : Sql dba
Is json a nosql?
What is the difference between an inner join and an outer join?
Can you have more than one trigger on a table?
What is sorting in sql?
How do you delete data from a table?
Explain ttitle and btitle.
How do you take the union of two tables in sql?
What are the benefits of pl/sql packages?
