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
Does group by remove duplicates?
Is it possible to sort a column using a column alias?
How do I view tables in sql developer?
What are basic techniques of indexing?
How do I kill a query in postgresql?
Why do we create stored procedures & functions in pl/sql and how are they different?
what are myisam tables? : Sql dba
What is the difference between alter trigger and drop trigger statements?
Is it possible for a table to have more than one foreign key?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is latest version of sql?
What are types of joins?
What is a dirty read sql?
What do you understand by pl/sql packages?
How do you delete duplicates in sql query using rowid?
