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

Explain the difference between 'between' & 'and' operators in sql

1004

Define commit?

1009

what does the t-sql command ident_current does? : Transact sql

985

What is difference between hql and native sql?

1177

What is database sql?

1058

what is a trigger in mysql? Define different types of trigger. : Sql dba

1071

How to find 3rd highest salary of an employee from the employee table in sql?

1083

Can we join 3 tables in sql?

1047

What is mutating error in pl sql?

1023

Is join and inner join the same?

1009

What are the set operators in sql?

1076

Do stored procedures prevent sql injection?

971

What is view? Can we update view

1442

How do I run a pl sql procedure in sql developer?

974

Explain the rollback statement?

1015