what is meant by tuning and tk proof?

Answers were Sorted based on User's Feedback



what is meant by tuning and tk proof?..

Answer / 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

what is meant by tuning and tk proof?..

Answer / suresh somayajula

Tkproof is a tool by Oracle to format the trace file Output.

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are the advantages of VIEW?

5 Answers  


What are tables and fields in the database?

0 Answers  


What is sequence in sql?

0 Answers  


what is constraining table?

2 Answers  


What is clustered and non-clustered indexes?

4 Answers   Microsoft,






how to create object in plsql

3 Answers   Microsoft,


How do sql triggers work?

0 Answers  


How do I delete a trigger?

0 Answers  


what is explain plan?

4 Answers  


How do I view an execution plan in sql?

0 Answers  


What are the most important characteristics of pl/sql?

0 Answers  


What is a bitmap index?

4 Answers   Choice Solutions, Infosys,


Categories