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 are keys in sql?

0 Answers  

---

What is clustered index in sql?

0 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

What is foreign key and example?

0 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

Can we perform dml in function?

0 Answers  

---

What is bulk collections?

2 Answers  

---

Why is theta join required?

0 Answers  

---

Explain two easy sql optimizations.

0 Answers  

---

Why use stored procedures?

0 Answers  

---

What is a column in a table?

0 Answers  

---