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.

How to change sql*plus system settings?

0 Answers  

---

Is left join same as inner join?

0 Answers  

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

What is form and report?

0 Answers  

---

how to find 5th row ?

10 Answers  

---

---

What is PL/SQL Records?

0 Answers  

---

When do we use triggers?

0 Answers  

---

Why do we need view in sql?

0 Answers  

---

How many types of relationship are there?

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

What is parameter substitution in sql?

0 Answers  

---

How do I delete a trigger?

0 Answers  

---