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.

Can pl sql procedure have a return statement?

0 Answers  

---

What is the basic structure of PL/SQL ?

6 Answers  

---

What are the differences between in and exists clause?

0 Answers  

---

Can you have more than one trigger on a table?

0 Answers  

---

Can we join more than 2 tables in sql?

0 Answers  

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

0 Answers  

---

Is left join inner or outer by default?

0 Answers  

---

what is the difference between trigger and constraint?

3 Answers   HSBC,

---

What are operators available in sql?

0 Answers  

---

What is pl sql script?

0 Answers  

---

Explian rowid, rownum?

0 Answers  

---

What is the difference between left and left outer join?

0 Answers  

---