Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is meant by tuning and tk proof?

Question Posted / swapna

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 is an Integrity Constraint?

4 Answers  

What are the most important characteristics of pl/sql?

0 Answers  

how many values can the set function of mysql take? : Sql dba

0 Answers  

What is a transaction?

5 Answers  

What is flag in sql?

0 Answers  

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

What is the limitation on the block size of pl/sql?

0 Answers  

Cite the differences between execution of triggers and stored procedures?

0 Answers  

How many tables can a sql database have?

0 Answers  

What is record in pl sql?

0 Answers  

What is the syntax to add a record to a table?

0 Answers  

Which sql statement is used to return only different values?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories