PL/SQL - what is meant by tuning and tk proof?

GeekInterview.com > Tech FAQs > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 9 of 166

what is meant by tuning and tk proof?

Total Answers and Comments: 3

Last Update: July 12, 2007 Asked by: suneel

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 12, 2006 07:05:20

kehri_anurag

Member Since: January 2006 Contribution: 13

RE: what is meant by tuning and tk proof?

HI Suneel

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.

ex. SQL> tkproof xyz.trc to readme.txt

Is this answer useful? Yes | No

June 12, 2007 19:13:08

madhug56

Member Since: November 2005 Contribution: 13

RE: what is meant by tuning and tk proof?

Can you tell me something more about tk proof?? I mean how do we give input and what is the output?

Is this answer useful? Yes | No

July 12, 2007 04:20:46

vinit

RE: what is meant by tuning and tk proof?

tkproof is a oracle utility. it gives information about following parameters.

********************************************************************************
count number of times OCI procedure was executed
cpu cpu time in seconds executing
elapsed elapsed time in seconds executing
disk number of physical reads of buffers from disk
query number of buffers gotten for consistent read
current number of buffers gotten in current mode (usually for update)
rows number of rows processed by the fetch or execute call
********************************************************************************

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank