HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
- 1 Answers
- 8356 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 dense_rank?
How do you select unique values in sql?
Explain the uses of control file.
Does truncate remove indexes?
What is compilation error in pl sql?
Can primary key be changed?
How can I tell if sql is running?
what is sql in mysql? : Sql dba
How to create your own reports in sql developer?
What are procedures used for?
Why use subqueries instead of joins?
Which command is used to delete a package?
Do prepared statements prevent sql injection?
What are different types of statements supported by sql?
What are types of joins?
