kehri_anurag

 Profile Answers by kehri_anurag Questions by kehri_anurag

• Jan 12th, 2006

 

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

 

madhug56

 Profile Answers by madhug56 Questions by madhug56

• Jun 12th, 2007

 

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

vinit

• Jul 12th, 2007

 

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
********************************************************************************