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.

Answer / suresh somayajula

Tkproof is a tool by Oracle to format the trace file Output.

what is a primary key? : Sql dba

0 Answers  

---

Why do we need databases?

0 Answers  

---

Write a sql query to convert all character to uppercase after hypen.

0 Answers  

---

Explain the difference between drop and truncate commands in sql?

0 Answers  

---

How do I view a table in sql?

0 Answers  

---

---

what are the different index configurations a table can have? : Sql dba

0 Answers  

---

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

---

Can primary key be changed?

0 Answers  

---

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

---

What are pl/sql cursors?

0 Answers  

---

what is 'mysqlshow'? : Sql dba

0 Answers  

---