can you explain performance tunning in oracle(sql,PL/SQL)

Answer Posted / sushant

It is just to check whether the query which we provide is
quiet simple n takes less time to compile as compared to
other querys !!!
Mostly its a DBA part !!

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle thin client?

538


How to write a left outer join with the where clause in oracle?

629


How to load excel data sheet to oracle database

586


types of indexes and the rationale behind choosing a particular index for a situation.

1985


What is a Garbage Collection? and what is full recursive Garbage collection?

2389






What happens to the current transaction if the session is killed?

536


What is the use of oracle?

556


What is a trace file and how is it created in oracle?

554


Explain integrity constraint?

644


How will you write a query to get a 5th rank student from a table student_report?

1376


Why do we use bulk collect in oracle?

571


What happens to the current transaction if the session is ended?

527


How to drop a stored procedure in oracle?

592


What is a cognitive schema?

527


Calculate difference between 2 date / times in oracle sql?

572