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 sql*plus also have a pl/sql engine?
Can primary key be changed?
how to see the create table statement of an existing table? : Sql dba
When is a declare statement required?
What is the maximum database size for sql express?
Can we use rowid as primary key?
What is the difference between microsoft sql and mysql?
Can we write ddl statements in functions?
What are the different ddl commands in sql?
Where is all the data on the internet stored?
how to fetch common records from two tables? : Sql dba
What are the three pl sql block types?
Is it possible to read/write files to-and-from PL/SQL?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What are the subsets of sql?
