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

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1027

what is the difference between blob and text? : Sql dba

1006

What do we need to check in database testing?

1012

What are the parts of a basic sql query?

960

explain the advantages and disadvantages of stored procedure? : Sql dba

1001

when MSQL8.0 is in market

2070

Is sql low level language?

1011

What is difference between joins and union?

1116

Is sql easier than java?

1002

Is progress software supports to ( pl/sql )?

1033

What are the steps for performance tuning.

1326

When to use inner join and left join?

950

What are the different types of functions in sql?

1044

What is the difference between an inner and outer join?

1006

How does a self join work?

1099