Answer Posted / swapna
Tunning means Making the database application run
faster,faster means high througtput. You can also say
that when your program using so many resources and
performance is low,now TUNNING comes in the picture.
Tunning Considerations
1) database availibility.
2)Database hit percentages.
3)Memory Utilization. etc
Tunning Steps
1) Tune the database(normalization).
2) Tune the application design.
3) Tune the resource concetanation.
4) Tune the Operating System. etc
For Tunning some Tools are avaliable.
1) SQL Trace / Autotrace.
2) Explain Plan.
3) SQL analyser.
4) TKPROOF. Tkproof is a utility that convert the .trc file
(trace file,which is in semi readble
format) in to readble format.
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How does join work in sql?
What does sql stand for?
What is benefit of creating memory optimized table?
What is faster join or subquery?
What is sp_helptext?
What's the difference between inner join and left join?
What is normalisation and its types?
how to check server status with 'mysqladmin'? : Sql dba
What is crud stand for?
What will you get by the cursor attribute sql%rowcount?
How many joins in sql?
How to read/write files from pl/sql?
How do you delete data from a table?
What is exit statement?
Is stored procedure faster than query?