1.tracing 2.explain plan 3.auto tracing 4.AWR reports 5.using v$views

what are the methods using performance tunning in sql and
pl/sql

Question Posted / vyshak

Answer Posted / vyshak

1.tracing
2.explain plan
3.auto tracing
4.AWR reports
5.using v$views

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which join condition can be specified using on clause?

914

What are the two characteristics of a primary key?

942

What is a left join?

898

Is sql scripting language?

1000

What is difference between ms sql and mysql?

928

How to run sql statements with oracle sql developer?

1014

how to rename an existing column in a table? : Sql dba

973

Can I learn sql in a week?

1027

What is an exception in pl/sql?

1023

What does where 1 1 mean in sql?

995

What is graph sql?

946

What are stored procedures in mysql?

985

What are sql triggers used for?

974

How are functions and procedures called in PL/SQL?

1151

How do I add a database to sql?

1083