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 column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
How many types of functions are there in sql?
What is rank function in sql?
Name the operator which is used in the query for pattern matching?
How do you write an index?
Does truncate require commit?
What is record in pl sql?
what does the t-sql command ident_incr does? : Transact sql
What is faster join or subquery?
how to select unique records from a table? : Sql dba
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is scalar data type in pl sql?
How many types of relationship are there?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is the need of a partition key?
