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
Which kind of parameters cannot have a default value in pl sql?
how is myisam table stored? : Sql dba
Explain the difference between sql and mysql.
What are triggers in sql?
Does execute immediate commit?
What is the difference between an inner and outer join?
What is the basic form of sql query?
How do I find duplicates in a single column in sql?
write an sql query to find names of employee start with 'a'? : Sql dba
Can a foreign key be a duplicate?
What is AUTH_ID and AUTH_USER in pl/sql ?
What is the difference between delete and truncate commands?
How does a covering index work?
How do I partition in sql?
What is error ora-01000: maximum open cursors exceeded
