HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
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.
Is This Answer Correct ? | 3 Yes | 1 No |
hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com
what is the output of this query selet * from employee where 1=2 ??
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What are triggers and its types?
Is left join faster than inner join?
Explain table and field in sql?
How do I run a sql trace?
What are the Diff B/W Cursor and REF Cursor
When are we going to use truncate and delete?
wa procedure to return the month and the no'f developers joined in each month.
Does varchar need length?
How do you remove duplicates without using distinct in sql?