what are the methods using performance tunning in sql and
pl/sql
- 2 Answers
- 5959 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is pl sql script?
Can primary key be changed?
When you have to use a default "rollback to" savepoint of plvlog?
What is the advantage of index in sql?
How to get each name only once from an employee table?
What are some emotional triggers?
Which version of sql do I have?
how to rename an existing table in mysql? : Sql dba
Which command is used to call a stored procedure?
What is the difference between explicit and implicit cursors in oracle?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What are the different schemas objects that can be created using pl/sql?
how to include numeric values in sql statements? : Sql dba
How to create a menu in sqlplus or pl/sql?
what is data manipulation language? : Sql dba
