Interested to Buy Any Domain ? << Click Here >> for more details...
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
what are date and time intervals? : Sql dba
What are the different datatypes available in PL/SQL?
What is the difference between count 1 and count (*) in a sql query?
Why indexing is needed?
What are the types of records?
What is the difference between union and union all command?
what is acid property in database? : Sql dba
What is scalar data type in pl sql?
Explain sql data types?
what is a cursor? : Sql dba
How delete a row in sql?
What are the packages in pl sql?
What is clustered and nonclustered index in sql?
What is pivot query?
What is trigger and how to use it in sql?
