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 are the different functions in sorting an array? : Sql dba

1065

Can we create clustered index without primary key?

1000

what are the different type of normalization? : Sql dba

1065

Explain clause in sql?

1070

How to call shell script from pl sql procedure?

1356

Differentiate between % rowtype and type record.

1389

Is sql a dbms?

1059

What is trigger and types?

1068

What are inner and outer joins examples of both?

1009

What is the maximum rows in csv?

977

What is the difference between execution of triggers and stored procedures?

1155

List the ways to get the count of records in a table?

941

What does the hierarchical profiler does?

1124

What are analytical functions in sql?

1076

what is foreign key? : Sql dba

1105