what is meant by tuning and tk proof?

Question Posted / swapna

2 Answers
13470 Views
I also Faced
E-Mail Answers

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 benefits of using PL/SQL packages?

3 Answers

What are stored procedures in mysql?

0 Answers

Which software is used for pl sql programming?

0 Answers

What is pl sql collection?

0 Answers

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers Sierra Atlantica,

What is join view in sql?

0 Answers

Explain the difference between sql and mysql.

0 Answers

What are different types of sql?

0 Answers

What is offset in sql query?

0 Answers

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers Saman Bank, Sonata,

What are the data types allowed in a table?

3 Answers

What is the difference between null value, zero, and blank space?

0 Answers

For more SQL PLSQL Interview Questions Click Here