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 input buffer in sql*plus?

0 Answers  

What is trigger explain with example?

0 Answers  

Can we use update in sql function?

0 Answers  

How to find the count of letter "L" in HELLO

7 Answers   HP,

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

What is the use of index in hive?

0 Answers  

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

What does closing a cursor do?

0 Answers  

What is a primary key called that is made up of more than one field?

0 Answers  

What is delete command in sql?

0 Answers  

Enlist the data types that can be used in pl/sql?

0 Answers  

What is rownum?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories