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

When do we use group by clause in a sql query?

583


How do I reset a sequence in oracle?

609


Explain alias?

723


How to sort output in descending order in oracle?

587


What is BBED in Oracle?

700






What is the difference between Delete, Truncate and Drop in Oracle?

613


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1792


candidate key is subset of super key but not vice-verse explain

1586


How to select an oracle system id (sid)?

599


How to delete a user account in oracle?

558


What is the difference between online and offline backups?

567


What is a procedure in oracle?

624


How can we view last record added to a table?

618


How do I spool to a csv formatted file using sqlplus?

555


How data locks are respected in oracle?

588