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 do you pronounce sql?
What is the basic form of sql query?
how to convert character strings to numeric values? : Sql dba
What is foreign key in sql with example?
How do you define a foreign key?
What are pl sql data types?
What is mutating trigger?
What are the types of views in sql?
What is exit statement?
What is function and procedure in pl sql?
what are ddl statements in mysql? : Sql dba
What is rtm in testing?
What is mutating table error?
Is keyword pl sql?
What are the different types of sql commands?
